S SAN04 Member Jan 27, 2025 #1 Need help on automation of serial number with combination of Numbers and Alphabet viz. 1A 1B 1C AND BEYOND IN EXCEL
Need help on automation of serial number with combination of Numbers and Alphabet viz. 1A 1B 1C AND BEYOND IN EXCEL
Belleke Well-Known Member Jan 27, 2025 #2 Maybe something like this, your example doesn's say anything where we can work with. Attachments BAA000.xlsx 39.2 KB · Views: 10
L Logit Active Member Jan 28, 2025 #3 How about in A2 paste : Code: =IF($A1<>"", "BAA"&TEXT(VALUE(RIGHT($A1,3))+1, "000"), "") Then drag that formula down Column A.
How about in A2 paste : Code: =IF($A1<>"", "BAA"&TEXT(VALUE(RIGHT($A1,3))+1, "000"), "") Then drag that formula down Column A.