Forum Discussion
Excel incrementing
Can someone please tell me how to increment by 1 the numbers only when you have letters with the numbers? For example: I have B-001A and need to increment the 001 by 1, so that when I drag it down I ...
If you try this formula, you only have to adapt it to your needs or cells.
=LEFT(A1,3) & RIGHT(A1,5)+1
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)