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. Or I want to extract "hours" field from "Task" column in below picture: (Extract hours field in … Continue reading Good Tip – Flash fill in Microsoft Excel to recognize and fill data for you automatically