Microsoft Office Tutorials and References
In Depth Information
Entering data quickly by using Flash Fill
Entering data quickly by using Flash Fill
Your data sets might contain values in a single cell that you’d
like to divide into separate cells. For example, your worksheet
might contain a list of names where the first name, middle
initial, and last name all appear in the same cell. If you need to
separate the first name, middle initial, and last name into
separate cells, you can do so by using Flash Fill, which is new in Excel
2013.
value for that cell. For example, your list might contain the name
Mark Hassall. If you want to store the person’s first name in one
cell and last name in another, you would type Mark in the first
cell and hassall in the second. You then repeat the process for
the second row of the list, at which point Flash Fill recognizes
the data pattern and offers to fill in the remaining values.
If your data set contains rows with additional data, such as a
middle initial, you can correct the first example of that differing
pattern to update similar rows in the new columns.
To use Flash Fill, click a cell to the right of the list that contains
the data that you want to work with, and then type the correct
Separate data by using Flash Fill
1 Click the cell to the right of the first row that you want to work with.
2 Type the value that 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
remaining rows.
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
data.
1
2
4
3
5
Search JabSto ::




Custom Search