Increase cell by +1 to previous cell

If you have the number 1 in cell A1, then in A2 enter: =A1+1 then hit enter.

Then you can hover over the lower right corner of cell A2, a small square will appear. Click and hold on that square, and drag down however many rows you need to increase the count, then let go of the mouse button.

- Moo

OK, if your range starts in cell A1, you can try this in A2:

=LEFT(A1,FIND("-",A1))&TEXT(RIGHT(A1,2)+1,"00")

- Moo

=LEFT(A1,FIND("-",A1))&TEXT(RIGHT(A1,2)+1,"00")

The LEFT function, as written, is looking in cell A1 for a -, and will return all of the characters up to and including the -
So, in your example (0040-01), it finds the - at character 5, and returns 0040-

The "&" combines the two operations so the output is concatenated into one cell

The RIGHT function, as written, is getting the last two digits of cell A1. I then add 1 (+1) to those digits to increment the value, which results in 0040-2

To format it as 02, the TEXT function handles that by defining the format as "00"

Hope that helps!

- Moo

@ Moo the Dog,

Very nice and well explained.

Thanks Winon. Appreciate the comment.

- Moo