Introduced in Excel 2013, Flash Fill will allow you to extract characters from a column of data or concatenate data from columns without writing a formula.