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



http://www.youtube.com/watch?v=1HSOHmosevg&hl=en

Hot Game !!!