Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Separate last word in cell with more than 2 words?
I know how to use =RIGHT to separate the last name when there are only 1st
and last name. How do I separate the last name when there are 3 or more words in the name? EX: Linda Jane Ellen Doe or Mrs. Linda Ellen Doe I have a column of names for an address list but the entire name was keyed into each cell in column A (Mr. & Mrs. John H. Doe). I want to separate the last name so that I can sort the list of names in alphabetical order. |
#2
|
|||
|
|||
Try this one
=IF(ISERR(FIND(CHAR(32),TRIM(A3),1)),"",MID(A3,FIN D("^^",SUBSTITUTE(A3,CHAR(32),"^^",LEN(""&A3)-LEN(SUBSTITUTE(A3,CHAR(32),""))))+1,1024)) -- Regards Ron de Bruin http://www.rondebruin.nl "Pat Mayton" <Pat wrote in message ... I know how to use =RIGHT to separate the last name when there are only 1st and last name. How do I separate the last name when there are 3 or more words in the name? EX: Linda Jane Ellen Doe or Mrs. Linda Ellen Doe I have a column of names for an address list but the entire name was keyed into each cell in column A (Mr. & Mrs. John H. Doe). I want to separate the last name so that I can sort the list of names in alphabetical order. |
#3
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I imbed a Word document into an Excel cell? | Excel Discussion (Misc queries) | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) | |||
COUNTIF text where there is more than one word in a cell | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Count the number of words in a cell! | Excel Worksheet Functions |