Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how the Flash Fill feature in Excel 2013 can extract First and Last Names from a column with first and last name. Much Easier than using formulas with the functions LEFT, SEARCH, and REPLACE.