On the Data tab, in the Data Tools group, click Flash Fill (or press CTRL + E). Click Flash Fill. Result: Flash Fill in Excel. Example 2. Use flash fill in ...