Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tough One. Data on one cell seperated by comas. | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Email addresses in Excel need to format for mass email | Excel Worksheet Functions | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions |