I have a list of email address (i.e. "adrian@somedomain.com" <adrian@somedomain.com>, adriana lastname <adriana.lastname@adifferentdomain.com>) and they are all in one field in excel, how do I separate them so each email is in its own field in a column?
First, 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
Ad Choices