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

"Tammy" wrote in message
...
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