A new Excel 2013 feature called Flash Fill can help. Enter the first name or other value in the column next to your data and press Enter. ... Start typing the ...
Split a column of data based on what you type | Microsoft Support
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.
