Solved separating email addresses in excel

Microsoft Excel 2010
October 28, 2010 at 07:42:13
Specs: Windows 7
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?

See More: separating email addresses in excel

Report •


#1
October 28, 2010 at 09:59:29
Data...Text To Columns...Delimited...;

Copy...PasteSpecial...Transpose


Report •

#2
October 28, 2010 at 10:05:33
✔ 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/


Report •

#3
October 28, 2010 at 10:34:06
Worked perfect, thanks.

Report •
Related Solutions


Ask Question