Apr 29 2020 09:12 PM
Hi All,
Probably a stupid question however, I have a large list of clients that have to be uniquely numbered.
The problem is I need a prefix "SUB" as part of the identifier eg SUB0001, SUB0002 and so on. Any suggestions would be greatly received.
Apr 29 2020 10:01 PM
Solution@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.
Apr 29 2020 10:17 PM
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
Apr 29 2020 10:22 PM
@Malcolm McMaster My pleasure!
Apr 29 2020 10:01 PM
Solution@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.