Forum Discussion
Formula Required Sequential numbering of cells
Malcolm McMaster The easiest way would be to just enter the first client number as SUB0001. Then, hover the cursor over the small square in the bottom-right corner of the cell. The cursor will change to a (smaller) black + sign. Click (and hold) and drag down. Excel will automatically increase the numerical part of the text string by one. Or, if you already have data in adjacent cells, just double-click the small square and it will fill down until the end, automatically. If you enter the first as SUB0001 and below it, for example, SUB0003 and select both cells and then do the drag or fill operation, Excel will recognise the pattern and increase each of the following numbers by 2 (so SUB0005, SUB0007 etc.) Try and see.
Malcolm McMaster The easiest way would be to just enter the first client number as SUB0001. Then, hover the cursor over the small square in the bottom-right corner of the cell. The cursor will change to a (smaller) black + sign. Click (and hold) and drag down. Excel will automatically increase the numerical part of the text string by one. Or, if you already have data in adjacent cells, just double-click the small square and it will fill down until the end, automatically. If you enter the first as SUB0001 and below it, for example, SUB0003 and select both cells and then do the drag or fill operation, Excel will recognise the pattern and increase each of the following numbers by 2 (so SUB0005, SUB0007 etc.) Try and see.
Genius, I've actually found a formula that achieves what I wanted, but I have to say your solution is way better & much simpler. I usually look for the complicated solutions to the simplest problems.
Many thanks Rint
Malcolm McMaster My pleasure!
