How to Manage Data By Using Flash Fill in Microsoft Excel

Manage Data By Using Flash Fill in Microsoft Excel

If you manage data in Microsoft Excel so you always want to combine data from several cells into one single cell to convert the form of data into information. for example, Concatenate two value in one cell etc. 

For this purpose we use Flash Fill command in Microsoft Excel. Flash is absolutely amazing command or tool that you can use in Microsoft Excel to manage your data very easily. 

Flash fill examples mentioned below:
  1. Extract first name from full name.
  2. Concatenate names.
  3. Format National Identity number.


Example # 1: Extract first name from full name:
Assume that you have an employees name data sheet as mentioned below:

You can easily get first name from full name through Excel Flash Fill by following below mentioned steps:

Step 1: Select the cell, where you want a first name.

Step 2: Enter the first name of your employee in selected cell.

Step 3: Select the cell right below the one where you entered first name of your second employee.

Step 4: After selection, Click on Data tab and within Data tools, Now Click on Flash Fill.

Now the result as mentioned below. Excel Flash Fill would automatically fill all the cells with the first name from the employees name data.

You can also use short-key (Ctrl + E) to use Flash Fill in Excel.

Example # 2: Concatenate Names.
Assume that you have an employees name data sheet which consist of First name and Last name as mentioned below:

You can easily combine the name through Excel Flash Fill by following below mentioned steps:

Step 1: Select the cell, where you want a combine name.
Step 2: Enter the full name in selected cell.
Step 3: Now Select the cell right below the one where you entered full name automatically.
Step 4: After selection, Click on Data tab and within Data tools, Now Click on Flash Fill.

Now the result as mentioned below. Excel Flash Fill would automatically fill all the cells with the full name easily.

You can also use short-key (Ctrl + E) to use Flash Fill in Excel.

Example # 3: Format National Identity Number.
You can use Flash Fill to format the numbers like your Identity card number your phone number etc.

You can easily create a format of your National Identity Number by following below mentioned steps:

Step 1: Select the cell, where you want to format your National I.D number.
Step 2: Enter your desired format of your National I.D number.
Step 3: Now Select the cell right below the one where you entered National I.D format automatically.
Step 4: After selection, Click on Data tab and within Data tools, Now Click on Flash Fill.

Now the result as mentioned below. Excel Flash Fill would automatically fill all the cells with the formatted National I.D number easily.

You can also use short-key (Ctrl + E) to use Flash Fill in Excel.


---Thank You---

Post a Comment

1 Comments