Once I paste email addresses seperated only by comas into Excel h.

[Red Scoop]

Once I paste a large list of email addresses seperated only by comas into
Excel how do I make them each go into their own cell? The entire list is
currently ALL in one cell but I need each of the thousand email addresses to
be in it's own individual cell.

Thanks!

 

[Anne Troy]

Paste into Word instead. Then Ctrl+H.
Type a space into the Find What
Type ^p into the Replace with and replace all.
Select all the addresses. Hit Table-->Convert Text to Table (one column).
Copy and paste THAT into Excel.
There's probably a fancy way, but this would be a quick way.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[dlw]

make sure the file ends in .txt, in excel do a file/open for Files of Type
pick text files, select the file, then pick delimited, next, pick coma, etc