Excel - Split Full Names into First and Last with the LEFT, RIGHT, FIND, and LEN Functions

full blog post: http://odyscope.com/text/split-full-names-into-first-and-last-with-the-left-right-find-and-len-functions/ Problem: Your data has a column for full name, and you need to create columns for first and last name. If you're using Excel 2013, the Flash Fill feature may not be adequate because you need an auditable and verifiable methodology (i.e. use formulas). Solution: Write two formulas, one for first name and one for last name. For first name the formula will use FIND and LEFT. For last name the formula will need RIGHT, FIND, and LEN.