Flash Fill in Excel
How to Use Flash Fill in Excel
Flash Fill in Excel used for Separate first name and last name from a single column, or combine first and last names from two different columns. This is big problem for every working employee to separate data of any column. Flash Fill is only available in Excel 2013 and later version. Flash Fill Video Tutorial
Separate First Name and Last Name in Excel
To separate first name and last name from single cell we use flash fill tool in excel which is availabe in excel 2013 and above version, Steps are given below;
- Suppose first name in A1 and Last Name in B1 column
- Type first name in column C1
- Type last name in D1
- Select all entire column
- press Ctrl+E or Click on Data Tab >> Choose Flash Fill Command
- Now Done
Combind First Name and Last Name in Excel
To Combind first name and last name in single cell we use flash fill tool in excel which is availabe in excel 2013 and above version, Steps are given below;
- Suppose Employee Name A1 column with first and last name
- Type first name in column B1
- Type last name in C1
- Select all entire B1 column
- press Ctrl+E or Click on Data Tab >> Choose Flash Fill Command
- All First name fill in
Shourtcut for Flash Fill in Excel
CLT+E
Add MR. Before All Employee Name
To add MR. before all employee name first type MR. then type employee name next select desired column and use Flash Fill Command.
If Flash Fill doesn't generate the preview, it might not be turned on. You can go to Data > Flash Fill to run it manually, or press Ctrl+E. To turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box.
Downlaod Excel file for Practice Flash Fill in Excel