Good Tip – Flash fill in Microsoft Excel to recognize and fill data for you automatically

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:

(Extract hours field in [] bracket)

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.

More interesting example here:


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.