| 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. |
| 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 | |||
Threaded Mode
