REVERSE SINGLE CELL TEXT STRING

[Guest]

I have a spreadsheet that lists names in a single cell (John Smith) I want
it to read as (Smith, John) in the cell to the left. Can you please advise
on how I can accomplish this.

thanks

 

[Guest]

http://www.cpearson.com/excel/FirstLast.htm

 

[Biff]

As long as the names have only two words:

=MID(A2&", "&A2,FIND(" ",A2)+1,LEN(A2)+1)

John Smith returns: Smith, John

If some names are more than 2 words then I'm not sure how to do it because
there are too many variables to consider. For example:

John Lee St. Pierre Jr.

???????

Biff