Microsoft Office Tutorials and References
In Depth Information
Extracting last names
Extracting last names
In this example, we want to extract the last name of each president, so the list can be sorted by last
name. This is a simple job for Flash Fill. It takes only two examples, and the pattern is recognized.
Figure 64-2 shows the worksheet after Excel extracted the last names. Now, you can sort the list by
column C, so the name will be in alphabetical order, by last name.
Figure 64-2: Flash Fill extracted the last names.
Extracting first names
You’ll find that Flash Fill is equally adept at extracting first names. Figure 64-3 shows the list of
presidents after using Flash Fill to extract the first names in Column D. Again, it took only two examples
before Excel identified the pattern.
Figure 64-3: Flash Fill extracted the first names.
Search JabSto ::

Custom Search