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:

[1] https://support.office.com/en-ie/article/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7

Leave a Reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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.