![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com