Microsoft Office Tutorials and References
In Depth Information
Taking the Drudgery out of Data Entry
Fill it in a flash
Excel’s brand new Flash Fill feature gives you the ability to take a part of the
data entered into one column of a worksheet table and enter just that data in
a new table column using only a few keystrokes. The series of entries appears
in the new column, literally in a flash (thus the name, Flash Fill), the moment
Excel detects a pattern in your initial data entry that enables it to figure out
the data you want to copy. The beauty is that all this happens without the
need for you to construct or copy any kind of formula.
The best way to understand Flash Fill is to see it in action. In Figure 2-13,
you see a new data table consisting of four columns. The cells in the first
column of this table contain the full names of clients (first, middle, and last),
all together in one entry. The second, third, and fourth columns need to have
just the first, middle, and surnames, respectively, entered into them (so that
particular parts of the clients’ names can be used in the greetings of form
e-mails and letters as in, “Hello Keith,” or “Dear Mr. Harper,”).
Figure 2-13:
Data Table
containing
full names
that need to
be split up
in separate
columns
using
Flash Fill.
Search JabSto ::




Custom Search