Hello I have a long string of email addresses - in the hundreds that are all in one line. They are bracketed by <> and separated by ;.
How do I parse them into their own cell?
Example:
Fred Johnson<fred.johnshon@bla.com>;Jaime Post<jpost@yahoo.com>'.........
I want to turn into.
Fred.johnshon@bla.com
Jpost@yahoo.com
.
.
.
.
Thanks for the help!
How do I parse them into their own cell?
Example:
Fred Johnson<fred.johnshon@bla.com>;Jaime Post<jpost@yahoo.com>'.........
I want to turn into.
Fred.johnshon@bla.com
Jpost@yahoo.com
.
.
.
.
Thanks for the help!
Last edited by a moderator: