I don't know if you had posted actual email addresses, but I edited them to ensure that they were not valid. It is never a good idea to post actual email addresses in a public forum.
It's less about caring whether the people receive spam and more about the security of our forum. We do not want to become known as a forum where valid email addresses can be harvested. Once the bad guys get in, it's really hard to get them out.
As for your question, take a look at the Text-To-Columns feature on the Data ribbon.
You should be able to use the Delimited option to separate the data at a specific character, perhaps the comma.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03