• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help on serial numbers automation

SAN04

Member
Need help on automation of serial number with combination of Numbers and Alphabet viz.
1A
1B
1C
AND BEYOND

IN EXCEL
 
Maybe something like this, your example doesn's say anything where we can work with.
 

Attachments

  • BAA000.xlsx
    39.2 KB · Views: 10
How about in A2 paste :
Code:
=IF($A1<>"", "BAA"&TEXT(VALUE(RIGHT($A1,3))+1, "000"), "")

Then drag that formula down Column A.
 
Back
Top