I've got names and emails exported from one sales system that I am trying to move into my email service provider. I have to normalize the data.
The email field has data like this:
John Smith <email@example.com>
I want to algorithmically turn all email field entries into this:
Do you know the best tool, script, process or excel function to do this? It's racking my brain, because I don't want to do it manually.