Switching from (Last Name, First Name) to (First Name, Last Name).

Posted by Ryan on January 28, 2002 7:15 AM

Hi, i have an excel file with many names, all of which are in this format:
Smith, John K

I would like to change it so they appear as:
John K Smith

Thanks

Posted by Keiser on January 28, 2002 7:29 AM

Try it. It works if the comma is really there.

=TRIM(RIGHT(E4;LEN(E4)-SEARCH(",";E4))&" "&LEFT(E4;SEARCH(",";E4)-1))

If you want explanation of the formula e-mail me.

Good luck, hope it works

Posted by Keiser on January 28, 2002 7:31 AM

Of course E4 is just my sample cell, you'll have to change it to meet your requirements.

Have a nice day.

Posted by Stephen Hoadley on January 28, 2002 7:35 AM

I would select the column and then goto Data Text To Columns select the Delimited Option and select the space option.

This would the separate the name into 3 columns you could then use the formula
=C5&" "&B5&" "&A5
to put them in the order you want.

then select the column and copy paste special values only

Hope This Helps