This can greatly reduce your dependence on text-parsing functions such as LEFT, RIGHT, MID, FIND, LEN, UPPER, LOWER, etc. Sample Scenario: If you have a column that contains the first and last names of employees, you could enter just the last name of an employee into the adjacent column and then use Flash Fill to fill-in the corresponding values of all of the last names of the employees within the column.Splitting a single name column into separate first name and last name columns (or vice versa).You use the Flash Fill feature to automatically fill-in values in one column from information referenced from another, adjacent column (extract, combine/concatenate, insert characters, reverse data, change case, format, etc.). In this case, Flash Fill can do the work for you. Say you have information in Excel not formatted the way you need it to be and going through the entire list manually to correct it seems daunting. However, did you know there is a similar feature that is equally useful called Flash Fill? You are probably familiar with Excel’s very powerful Autofill feature (if not, learn more about Autofill here and then read on).
