Microsoft Excel Hints and Tips

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 ?

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)

Back to Questions Index

Return to Excel Exchange homepage.