Question

[JRCBoston]

In my spreadsheet I want to change the way that names are displayed.

For instance, in column A the names are listed as follows: "John Smith" and I want to change it to read "Smith, John".

Given that names are of differing lengths, is there any easy way to do this?

Thank you.

 

[QuietRiot]

http://www.excelchampion.com/tip08.htm


=TRIM(SUBSTITUTE(A2,LEFT(A2,FIND(" ",A2)),"")&", "&LEFT(A2,FIND(" ",A2)))