+ Reply to Thread
Results 1 to 7 of 7

add alpha character

  1. 11-10-2009, 12:32 PM #1
    thillis
    thillis is offline
    Registered User
    Join Date
    10-08-2009
    Location
    Granite Falls, NC
    MS-Off Ver
    Excel 2003
    Posts
    17

    add alpha character

    I want to add a letter to the end of value and have it start over at "A" when the cell value changes. For example


    My Column contains
    BIR1510
    BIR1522
    BIR1524
    BIR1524
    BIR1524
    BIR1524
    BIR1532
    BIR1532
    BIR1533

    I want this in another column
    BIR1510A
    BIR1522A
    BIR1524A
    BIR1524B
    BIR1524C
    BIR1524D
    BIR1532A
    BIR1532B
    BIR1533A


    Thanks for any help or sugestions
    Last edited by thillis; 11-10-2009 at 01:01 PM.
    Reply With QuoteRegister To Reply
  2. 11-10-2009, 12:34 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: add alpha character

    In B1 and copy down, =A1 & CHAR(64 + COUNTIF(A$1:A1, A1))
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 11-10-2009, 12:38 PM #3
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: add alpha character

    =a1&char(countif($a$1:a1,a1)+64)
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  4. 11-10-2009, 12:39 PM #4
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: add alpha character

    i claim a snap
    Reply With QuoteRegister To Reply
  5. 11-10-2009, 12:41 PM #5
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: add alpha character

    Hi,

    With your list starting in A2 in B2:

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  6. 11-10-2009, 01:01 PM #6
    thillis
    thillis is offline
    Registered User
    Join Date
    10-08-2009
    Location
    Granite Falls, NC
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: add alpha character

    Thanks for all the quick help. I used shg's formula and it worked perfectly. Thanks again now I can eat lunch today.
    Reply With QuoteRegister To Reply
  7. 11-10-2009, 01:02 PM #7
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: add alpha character

    I'd recommend Richard's if your data is sorted ascending -- it's lighter weight.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1