Скачать или смотреть 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

Please subscribe to our page for more random tidbits of knowledge and reach out to us if you'd really like to kick up your analytics game. https://www.adaptalytics.com