Reversing Text in cells

[Truc Lopez]

I have a list of names in a column that were entered as First Name then Last
Name. Is there a way to transposing all of the names so that they read Last
Name, then First Name?

Example:

currently - Chris Lopez
desired outcome - Lopez, Chris

 

[Gary''s Student]

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1))

 

[T. Valko]

As long as the names are only 2 word names:

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

If you have names like: John Paul De La Cruz Sr. = good luck!!!

 

[Truc Lopez]

Thank you!!!!

 

[CLR]

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1))

Returns a trailing space......this drops it

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1)-1)

Vaya con Dios,
Chuck, CABGx3