Flash Fill in Excel

Flash Fill feature in Excel was introduced in 2013 and onward additions, the auto-fill option is used to enter repetitive information such as dates in an easy and fast way without manual addition one by one.

Separating first name and last name using flash fill

1.  Tell Excel what do you want to do by adding value in cell C3.

2. Go to Data tab, Select Flash Fill in Data Tools section.

3. after clicking Flash Fill, the first name will appear automatically in C4, C5 and C6 cell.

You may perform the same function by using short key: Ctrl + E.

Concatenating last name and first name with comma separation

1. Write last and first name value in the cell with comma separation.

2. Press Ctrl + E or go to Data tab, Select Flash Fill in Data Tools section.

Extracting initials from full names

1.  Type initial in cell C3.

2.  Press Ctrl + E or go to Data tab, Select Flash Fill in Data Tools section.

Changing format of phone numbers

1. Type the desired format in the cell where you want to apply flash fill function.

2. Press Ctrl + E or go to Data tab, Select Flash Fill in Data Tools section.

Note: Flash fill function can not recognize source data modification.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved