Microsoft Office Tutorials and References
In Depth Information
Entering data by using Flash Fill
Separate data by using Flash Fill
1 Click the cell to the right of the first row you want to work with.
2 Type the value you want to extract from the row, and press Enter.
3 In the cell directly below the first, start typing the extracted value
for the row.
4 Press Enter to accept the suggested Flash Fill values for the
5 If desired, repeat the process in the cell to the right of the first cell
in the new column to extract another value from the row’s original
TIP You must type a value that is distinct from other values in
the column for Flash Fill to work. For example, if the name
Hassall appears in the row, you must type the characters Har in
Harrison to distinguish it from Hassall , which also begins with Ha.