How to parse text in Excel with hyphen, en dash and em dash problems

This video explains the difference (nuance) of a hyphen, an "en dash" and an "em dash" and shows how to verify which ones you're dealing with as well as how to resolve their differences when parsing text. We've run into this a slew of times over the years and while we can easily navigate around it, it trips up a lot of people because they aren't aware of this nuance (you're not crazy if you've struggled with this before).

Hopefully this will save you some time and make your life easier. Excel functions used in the video: MID, FIND, CODE, IFERROR

[douglasbrown]

thanks using this with chat gpt to make hundreds of language flashcards really fast

[douglasbrown]

how would I go backwards ?
to take the frost part and paste it in another
colum