How to make a report number with spaces ascend in proper order

  • I have made a worksheet with report numbers starting with '03 19001', I need it to change to '03 19002' but every time I try to drag the number down it changes the 03 to an 04 and doesn't change the last number? How do I fix this please?

  • Hello,

    If we assume the starting cell is cell A2 with 03 19001 ...

    you could test in cell A3 the following formula :

    =LEFT(A2,2)&" "&VALUE(MID(A2,4,5))+1

    and then ... copy the formula down ...

    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!