Microsoft Office Tutorials and References
In Depth Information
Filling cells and creating data series
worksheet, where we used Flash Fill to help parse the last names into column B, and after
entering the first letter of the second name in cell C3, Flash Fill intervenes with a complete
column of suggested entries.
Figure 8-35 Flash Fill can parse as well as it can concatenate.
Flash Fill works well as long as your data is consistent, but even if it isn’t, it will
probably save you a lot of work. For example, if you have a column containing middle names,
but not all of its cells contain data, you might need to edit extra spaces from individual
cells after using Flash Fill. (Whether your data is consistent or not, you should always
check your results.) If your data is too inconsistent for Flash Fill, try using functions, as
described in “Understanding text functions” in Chapter 14, “Everyday functions.”
Flash Fill performs another neat trick: changing the case of text. For example, suppose some
of your source data is in all caps, such as cells A4, B5, and A8:B8 in the worksheet shown
in Figure 8-36. Using the same method of typing in examples, the results shown in Figure
8-36 were suggested by Flash Fill after typing the first letter in the second name.