how to separate emails in excel that are all in one cell?

June 8, 2015 at 20:28:01
Specs: Macintosh
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?

See More: how to separate emails in excel that are all in one cell?

Report •

#1
June 9, 2015 at 04:01:43
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


Report •
Related Solutions


Ask Question