Excel’s Flash Fill is a time-saving feature which fills in data for you when a pattern is evident. It can also can extract and insert as well as format and concatenate. This feature can even reverse text, numbers, dates and much more.
ACTIVATE FLASH FILL:
If the Flash Fill does not work automatically, you need to activate in from Excel’s back end by going to:
File > Options > Advanced > Automatically Flash Fill
Separating First Name and Last Name Using Flash Fill
We have a list of full names in one column, and we will separate the data in this column into two individual columns using Flash Fill
Concatenating Last Name and First Name with Comma Separation
We have a lengthy list of full names in one column, and we wish to have the pattern: last name, comma, first name.
Extracting Initials from Full Names
We have the same list of full names. We will extract initials from the full names using Flash Fill.
Formatting Phone Numbers Using Flash Fill
Using Flash fill to format phone numbers, you can concatenate with brackets to make it easily readable.
Extracting Text before the Symbol @ from Email Addresses
With the Flash fill feature, extracting text before the @ symbol from email addresses is simple
Note: Flash Fill cannot recognize source data modification. If you apply Flash Fill on source data and then try to modify the source data, Flash Fill cannot recognize the changes and make modifications in available results as Excel formulas do. Therefore, it is best to use Flash Fill with data which is not going to be modified in the future.