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

About this tutorial:

Video duration: 7:50
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

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads