Home/ Questions/Q 2570
Next
Answered
computing
  • 2
Asked: 2021-10-28T12:01:15+00:00 In:

Solved Separating Email Addresses In Excel

  • 2

I have a list of email address (i.e. joe@hotmail.com; mike@hotmail.com; bill@hotmail.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?

Share

    1 Answer

    1. Best Answer
      If there separated as shown in your example with a semicolon character, then TEXT TO COLUMNS is what you need.

      Hightlight the cell with the list of names
      Select TEXT TO COLUMNS
      Select Delimited
      Click Next
      Select Semicolon
      You should see your data delimited in the small window at the bottom
      Click Next
      Click Finish

      MIKE

      http://www.skeptic.com/

      • 0