Flash Fill automatically fills your data when it senses a pattern.
For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.
Or I want to extract “hours” field from “Task” column in below picture:
Within 100 or 1000 lines, It would take you hours to fill the “Hours” column manually.
There is another option is to write a complex commands to extract it.
In this post I will give you a tip to do it in 3 seconds by using Flash Fill in Microsoft Excel.
How can I do that ?
Step 1: Enter the a sample value in cell B2. In this case, It’s “[4]” then the cell value should be “4”.
Step 2: Continue to enter the next value in B4. It’s “1”.
Step 3: Press Ctrl + E. It will fill remaining cell for you.
Hung Doan 