Download Excel Start File: https://excelisfun.net/files/EMT1182-1183.xlsx

Download File: https://excelisfun.net/
See how to take a list of menu items with unwanted text after the dash and remove the unwanted text using:
1. (00:08) Flash Fill (Excel 2013 only)
2. (01:01) Flash Fill and keyboard Ctrl + E (Excel 2013 only)
3. (01:24) Test To Columns
4. (02:09) LEFT and SEARCH functions in a text formula that is dynamic and will extract the text even if the source data changes