Results 1 to 3 of 3

Thread: formula to sequence numbers with prefix

  1. #1

    formula to sequence numbers with prefix



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

    hi there - i'm somewhat of a novice with excel and was looking for assistance to complete a contact list spreadsheet. i have a column for contact ID numbers (column A) and i'd like to automatically assign a number to each contact and include as a prefix the two letter state code in their address (state is column G). i imagine this is doable and somewhat easy, but my excel talents are limited. thanks for your assistance!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Insert a column after A and use

    =H2&A2

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Insert a column after A and use

    =H2&A2
    thanks Bob. i feel like an idiot.

Posting Permissions

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