| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
extracting last name
I have names of individuals in Column A. Some have only first and last,
others also include the middle initial. I want to extract the last name of each person into Column B. I used the formula =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) which works great for those names that don't include the middle initial. How can I modify this to work for either situation? Thanks!!! -- maryj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
| Extracting File Names and Properties | Excel Worksheet Functions | |||
| Extracting data from other columns | Excel Worksheet Functions | |||
| Extracting a value from between brackets | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Threaded Mode
