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 ...
Not what you want. But a 3:d cheating version
Put numbers in column A
=ROW()
and use the number-format "00#"
at least 2 rows of Exemple data in B
Select B1:B9 press Ctrl+E for excels "intelligent" Flash Fill
| 001 | B-001A |
| 002 | B-002A |
| 003 | |
| 004 | |
| 005 | |
| 006 | |
| 007 | |
| 008 | |
| 009 |
Deleted
just a suggestion
Nikolino
I know I don't know anything (Socrates)