Excel Forum

Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not

See how to extract first, middle and last names when the list contains names where some have a middle name and some do not. See the functions LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID, and IF functions.
Text Functions

Got a Question? Ask it Here in the Forum.