Microsoft Office Tutorials and References
In Depth Information
Using Filter to Flash Fill a Subset of Records
10.
10. You are now free to format column G with any date format, including
M/D/YYYY, in order to leave off the leading zeroes.
Using Filter to Flash Fill a Subset of Records
Figure 2.13 shows a column with Movie Title (Year) Genre in each row. You
would like to extract these into three fields. You would also like to sort by
movie title, which means you want the word The to appear after the title.
Figure 2.13.
Figure 2.13. Because the headings are in B1 and C1, Flash Fill has no prob-
Because the headings are in B1 and C1, Flash Fill has no prob-
lem starting with Genre in D.
lem starting with Genre in D.
Fill in the headings of Title, Year, and Genre in row 1. Excel has no problem
filling the Genre.
Type 1968
1968 in C2 and start typing 1980
1980 in C3, and Excel fills the year (see Fig-
ure 2.14 ) .
Search JabSto ::




Custom Search