Chapter 25: Importing and Cleaning Data
2525
FIGURE 25.13
The goal is to extract the numbers in column A.
FIGURE 25.14
Using manually entered examples in B1 and B2, Excel’s Flash Fill feature makes some incor-
rect guesses.
As you can see, Excel identified most of the values. Accuracy increases if you provide more
examples. For example, provide an example of a decimal number. Delete the suggested
values in Column B, enter 3.12 in cell B6, and press Ctrl+E. This time, Flash Fill gets all of
them correct (see Figure 25.15).