Excel Magic Trick 1183

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

DESCRIPTION

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.




Be the first to comment

Leave a Reply