Flash Fill is a new feature in Excel 2013. Flash Fill will save you time. Flash Fill will save you having to write complex formulas in order to extract data from a single column or combine data from several columns.
You simply provide an example of what you want it to do and Excel will automatically will copy it down a column, updating the values in each row.
Last month we looked at the Preview version of Microsoft Office 2013 in a two part webinar. The video below is a recording of the Flash Fill section of the webinar.