Hello all,
I have several sheets I need to auto number with a specific prefix and number format.
I uploaded my test sheet to show you what I am trying to do
Using this formula: =CONCATENATE($B$1,ROW(B1)) I am able to use a cell as a prefix which is fine, but rather than it just numbering 1,2,3, etc, I need to have it in a specific number format such as:
TC_UA_001
TC_UA_002
TC_UA_003
TC_UA_004
TC_UA_005
TC_UA_006
TC_UA_007
TC_UA_008
TC_UA_009
TC_UA_010
.....
TC_UA_100 and so on
How can I achieve this please?
Bookmarks