Using Flash Fill in Excel
Using Flash Fill in Excel
Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.