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.
Fixing Excel Data Using Flash Fill - Excel Tips - MrExcel Publishing
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.