__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.