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

R

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!
 
A

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
****************************
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top