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

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!

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

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
****************************
"Red Scoop" <Red wrote in message
...
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!

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

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

"Red Scoop" wrote:

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!