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!
Bookmarks