Flash Fill

Flash fill is a new tool introduced in Microsoft Excel 2013, to fill out data based on an example.
 

Excel detect a pattern in your data, fill accordingly remaining data within a flash of time. It works best when your data has some consistency. Flash Fill is available in Data tab and Ctrl+E is a shortkey

Rather than manually entering first, middle, or last names in respective columns (or attempting to copy an entire client name from column A and then editing out the parts not needed in the First Name, Middle Name, and Last Name columns), you can use Flash Fill to quickly and effectively do the job.

For more detail check at office.com by clicking here.