Flash Fill - New Feature

Flash Fill is a new feature in excel, which is looking like it automated text to column feature in excel. Flash Fill identifies the patterns on dataset & give us the extracted output. You can download this demonstration file from this link.

Let's consider that we have a list of emails, which are created in following pattern.

email=first name.last name@emailprovider

Email

[email protected]

[email protected]

[email protected]

[email protected]

[email protected]

We are going to extract first name, last name & email provider from this list. In traditional way we can use text to column option in data tab in the ribbon. Using Flash Fill we don't even think to change the tab in the ribbon. Assume that first email in the cell A2. Then we are going to enter first name in column B, Last name in Column C and email provider in column D.

Just start typing from Cell B2. Enter first name of the first email to cell B2 & then enter relevant first name to cell B3. While typing you can see excel shows all first names as flash popup. Just press enter to confirm it. That's it. All first names are extracted.

Try to extract last name and email provider from this list.

See on YouTube