Excel Magic Trick 1183

Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula


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

Excel wild card characters ? and * for text only? Yes, this information was not in the F1 Help for COUNTIFS, but instead it was in the F1 Help for the MATCH function.