Flash Fill in Excel

Advertisements

Prev Tutorial Next Tutorial

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
separate first name and last name in excel

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
separate first name and last name in excel

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


Prev Tutorial Next Tutorial

Google Advertisment

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet


For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements