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,
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
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks