+ Reply to Thread
Results 1 to 2 of 2

Alpha-Sum

  1. #1
    Registered User
    Join Date
    12-22-2010
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    1

    Alpha-Sum

    I am trying to make an alpha-numeric code using several columns (sort of like a VIN code). The first column may have the letter "A", the second, "Z", third "Z", the fourth, a dash, the fifth a number like 60, and the sixth column contains two letters. For example, AZZ-60PO. Is there any formula to put all of them together for me?

    Thanks,

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Alpha-Sum

    You can just string all the values together like...

    =A1&B1&C1&D1&E1 and so on

    If you like you could also use the =CONCATENATE() function. See Excel help
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1