| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Parsing full name into salutation, First, middle, last, Suffix
I have large list of name in excel as below..............
Frank O. Martin G. E. Smith Susan Smith-Klein Jeffrey Chang Dr. Jack Johnson Smith, PhD Mr. Jim S. Van De Berg, Jr. How can separate them in different columns for Salutation, First Name, middle name, last name and suffix?? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding periods (full stops) to the middle of numbers | Excel Worksheet Functions | |||
| parsing a full name out into Last, First, Middle | Excel Worksheet Functions | |||
| Separating Full Names into First Middle and Last | Excel Discussion (Misc queries) | |||
| seperate a full name into first, middle, last, & suffix column | Excel Worksheet Functions | |||
| Parsing for middle initial | Excel Programming | |||
Threaded Mode
