Change persons initials to full name

[Shannon1234]

I have a large spreadsheet that contains our sales managers initials for all dealer accounts. We have about six sales managers so there are six different sets of initials. Is there a command I can do to change all of the initials to their full name (first, last)? Example change JS to John Smith.

 

[alansidman]

You could build a table with two columns with the initials in the first column and the name in the second

You could then do a Vlookup in a new column to find the name associated with the initials.

 

[Shannon1234]

You could build a table with two columns with the initials in the first column and the name in the second

You could then do a Vlookup in a new column to find the name associated with the initials.

After I do that, could I completely delete the column with the initials without it messing anything up?

 

[kweaver]

After you use the formula, do a copy and then paste special --> values.