Microsoft Office Tutorials and References
In Depth Information
Using Filter to Flash Fill a Subset of Records
Figure 2.14.
Figure 2.14. Extracting the year from inside the parentheses is easy.
Extracting the year from inside the parentheses is easy.
Type the first title in B2. Start typing a title in B3. Excel fills all the titles.
The problem is in rows 12:15, where you would like the titles to be in the
format of Pink Panther, The (see Figure 2.15 ) .
Search JabSto ::




Custom Search