Microsoft Office Tutorials and References
In Depth Information
Using Commas Helps Flash Fill
Figure 2.8.
Figure 2.8. Excel inserts four new characters in a pattern in the phone num-
Excel inserts four new characters in a pattern in the phone num-
ber digits.
ber digits.
Insert a new column C. Type a heading in C1. Retype the first phone number
in C2 as (907)
555-2750. As soon as you type the opening parenthesis in C3,
Flash Fill offers to fill in the rest of the column (see Figure 2.8 ) .
Note that the new values are static values. They are not formulas. After
Flash Fill works, you are free to delete the original column without having
to worry about the new column changing to #REF errors.
(907) 555-2750
Using Commas Helps Flash Fill
Using Commas Helps Flash Fill
I have two versions of the data set shown in Figure 2.9 . In the second version,
a comma is used in column D to separate the city and state. When there is a
comma, the Flash Fill in column F works perfectly to get the city every time.
Search JabSto ::




Custom Search