• 0

How To Separate Emails In Excel That Are All In One Cell?

  • 0

I have a list of email address (i.e. “” <>, adriana lastname <>) 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?


1 Answer

  1. 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

    • 0