Separate / Extract Data Flash Fill

Flash Fill was introduced in Excel 2016 and give you an easy way to split or extract text or values from one column cell to another. A common use is to split out a column with full name (i.e. first name last name like John Smith) to separate first and last name columns. Before you might have used LEFT, MID or RIGHT functions, but now with Flash Fill, there's no need to use those functions.