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