Monday November 3, 2014 at 9:29am
Easily the best new feature in Excel 2013, Flash Fill solves one of the most frustrating problems of Excel: pulling needed pieces of information from a concatenated cell. When you’re working in a column with names in “Last, First” format, for example, you historically had to either type everything out manually or create an often-complicated workaround.
Flash Fill can automatically add data formatted the way you want without using formulas.
In Excel 2013, you can now just type the first name of the first person in a field immediately next to the one you’re working on, and click Home > Fill > Flash Fill, and Excel will automatically extract the first name from the remaining people in your table.