MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Switch Name


Posted by Susie on June 25, 2001 2:20 PM

I have a spreadsheet that has Last Name, First Name. I'm merging this spreadsheet into Visio to do org. chart, but I want names to be First Name Last Name. How would I fix this in Excel?


Posted by IML on June 25, 2001 3:04 PM

You could use the following (assuming your name is in A1.

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)

Good Luck

Posted by Aladin Akyurek on June 25, 2001 3:10 PM

If you have them in separate cells, say First Name in A1 and Last Name in B1, you can run them together in C1 by

=A1&" "&B1

If you have them together in A1, do first Data|Text To Columns. They will be now in B1 and C1. Now apply the formula above in D1:

=C1&" "&D1

hope this helps.

Aladin

Posted by Susie on June 26, 2001 7:51 AM

Where would I put the above formula?

Posted by Aladin Akyurek on June 26, 2001 7:58 AM

In B1, if A1 contains names like Doe, John that is a lastname followed by a comma, then (a space) and a firstname. Names with middle initials might give some trouble.
Then copy down Ian's formula.

Aladin

===========

Posted by Susie on June 26, 2001 9:22 AM

Thank you very much -- it worked!!