Results 1 to 4 of 4

Thread: Formula to autofill letters at end of cell

  1. #1
    Neophyte exceluser1233's Avatar
    Join Date
    Oct 2020
    Posts
    3
    Articles
    0
    Excel Version
    2013

    Formula to autofill letters at end of cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have the same number in multiple rows and I'm looking to add _A, _B, _C, etc. to the end of each cell to make them unique. Does anyone know what formula I could use for something like this? The formula I've tried is substitute(address(1,rows(a$1:A1),4),1,"") but all i end up with is "A" rather than "12345_A"

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Try this

    =A1&"_"&CHAR(64+ROW(A1))

  3. #3
    Neophyte exceluser1233's Avatar
    Join Date
    Oct 2020
    Posts
    3
    Articles
    0
    Excel Version
    2013
    That did it. Thanks Bob - saved me a ton of time.

  4. #4
    Neophyte exceluser1233's Avatar
    Join Date
    Oct 2020
    Posts
    3
    Articles
    0
    Excel Version
    2013
    Quote Originally Posted by Bob Phillips View Post
    Try this

    =A1&"_"&CHAR(64+ROW(A1))
    Follow up question. After i get to 12345_Z is it possible to then have it fill as 12345_AA, 12345_AB etc?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •