Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing Text in cells
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1))
-- Gary''s Student - gsnu200765 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REVERSING CELLS? | Excel Discussion (Misc queries) | |||
Reversing a column. How? | Excel Discussion (Misc queries) | |||
Reversing characters of cells | Excel Discussion (Misc queries) | |||
reversing entry | New Users to Excel | |||
Reversing First & Last Name | Excel Worksheet Functions |