Exceljet

Quick, clean, and to the point

Flash fill

Windows shortcut 
CtrlE
Mac shortcut 
E

In a new column next to existing data, enter a value that represents what you want to extract, combine, etc. Then, in the cell below, use this shortcut. Excel will try to apply the same pattern to all rows in the data. You can use Flash Fill with text, numbers, and dates.

Flash fill is a new feature added in Excel 2013.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.