Concatenating data in cells into 1 cell?

Hello,

This is my first post here so sorry if it doesn't follow all of the rules.

I have an excel sheet that has a bunch of client data, and I have to go through and create a short-name for each client depending on certain values in columns and rows.

So on to how the data is sorted... Let's say that in column A the users' ID number is stored. Column B has the Company the user works for. Column C is the state the user is in, column D is the city and so on.

What I need to do is depending on what the user inputs, I have to go through the list and type the short-name for the user.
Example - User 1 works for company A, in Texas, in Houston. In Column E the short-name would be COA (Company A), Tx (Texas), H (Houston). All together it would look like this, COATXH.

Can I do this using the built-in functions in Excel?

Thank you for any help!

If you build some tables for those codes, You can combine some vlookups with concatenate.

Example
EFhushn0w.xlsx

Thanks for the answer! The problem is that I am not overly familiar with the functions in Excel. Someone suggested I use VLookup and Concatenate but I'm not sure how I would do that. If I post a sample file would you be able to show me?

Originally Posted by Glenn Kennedy

To attach a workbook:

Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Just before you submit your post, click on GO ADVANCED (near the bottom) and EITHER click "Manage Attachments" OR use the paperclip icon to open the upload window.
The paperclip icon

Thank you!
I will be uploading the file later today.