Microsoft Excel Hints and Tips
Question
I have a spreadsheet with a column containing employee names. The
names are displayed last name, first name. How can I reverse this so
that the names are displayed with the first name first and the last name
last ?
Solution
Suppose you have Smith Sarah in cell A1 - Type the following formula
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))&" "&LEFT(A1,SEARCH(" ",A1)-1)
If you have Smith, Sarah in cell A1 - Then type =RIGHT(A1,LEN(A1)-SEARCH(",",A1)-1)&" "&LEFT(A1,SEARCH(",",A1)-1)
Or if you have Smith,Sarah in cell A1 - Then Type =RIGHT(A1,LEN(A1)-SEARCH(",",A1))&" "&LEFT(A1,SEARCH(",",A1)-1)
Return to Excel Exchange homepage.