Microsoft Office Tutorials and References
In Depth Information
Using Filter to Flash Fill a Subset of Records
Figure 2.15.
Figure 2.15. Flash Fills gets the titles but does not understand the nuances
Flash Fills gets the titles but does not understand the nuances
of putting The after the title to allow for sorting.
of putting The after the title to allow for sorting.
Note
In this example, actually typing 2001:
Odyssey is a chal-
lenge. I would copy A2 to B2, press F2 to edit the cell, and backspace
through (1968) Sci-Fi to leave the movie title. After making that
edit, stay in column B and click Flash Fill to manually invoke the
command.
2001: A Space
Space Odyssey
One solution is to filter to the records that need further adjustment. Follow
these steps:
11. Choose one cell within the data set.
22. Click the Filter icon on the Data tab.
33. Open the filter drop-down in cell A1. Choose Text Filters, Begins
With.
Search JabSto ::




Custom Search