Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
batch importing of mailing lists to Excel
I've got a mailing list of around 1000 names, stored in both Word and
Entourage like this: First Name Last Name <e-mail address Once Ive eliminated the < , do I then have to individually copy & paste (or type) all the info in three Excel columns? Or is there a simpler solution for batch importing of mailing lists to the Excel spreadsheet? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
batch importing of mailing lists to Excel
"bgsignal" wrote: I've got a mailing list of around 1000 names, stored in both Word and Entourage like this: First Name Last Name <e-mail address Once Ive eliminated the < , do I then have to individually copy & paste (or type) all the info in three Excel columns? Or is there a simpler solution for batch importing of mailing lists to the Excel spreadsheet? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
batch importing of mailing lists to Excel
You can paste the whole list into excel and then use Data-Text to Column
option to break it into columns.. There are a number of posts here - just search for them if you need more information. "bgsignal" wrote: I've got a mailing list of around 1000 names, stored in both Word and Entourage like this: First Name Last Name <e-mail address Once Ive eliminated the < , do I then have to individually copy & paste (or type) all the info in three Excel columns? Or is there a simpler solution for batch importing of mailing lists to the Excel spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing Word lists into Excel | Excel Discussion (Misc queries) | |||
How do I compare two mailing lists. One Sent and one not sent? | Excel Worksheet Functions | |||
Access or Excel for contact info lists & creating mailing labels | Excel Discussion (Misc queries) | |||
Is it possible to create a mailing list in excel, not importing d. | New Users to Excel | |||
Changing case on mailing lists I receive in Excel 2003? | Excel Worksheet Functions |