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!