Reversing Text in cells
 

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

Reversing Text in cells
 

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1))
--
Gary''s Student - gsnu200765

Reversing Text in cells
 

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!!!

--
Biff
Microsoft Excel MVP


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

Reversing Text in cells
 

Thank you!!!!

"Gary''s Student" wrote:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1))
--
Gary''s Student - gsnu200765

Reversing Text in cells
 

=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



"Gary''s Student" wrote:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1))
--
Gary''s Student - gsnu200765