Microsoft Office Tutorials and References
In Depth Information
Using Commas Helps Flash Fill
This problem is a bit more insidious. There aren ’ t any blank cells to make
you realize that it did not work. Luckily, the problems are showing up in the
first part of the data, so you might notice the Las in F4. However, I can cer-
tainly foresee a situation where you have 9,000 records that say Henderson
and only five records that say Las Vegas, and those latter records don ’ t
start until row 8642. In such a case, it would be really tough to realize that
there is a problem.
Assuming you notice the problem, Excel can recover for you. Go to the first
cell that is wrong in the Flash Fill results and type the correct value.
Figure 2.10. Correct the first wrong cell, and Flash Fill makes the other
Correct the first wrong cell, and Flash Fill makes the other