ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   batch importing of mailing lists to Excel (https://www.excelbanter.com/new-users-excel/204204-batch-importing-mailing-lists-excel.html)

bgsignal

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?

Sheeloo[_2_]

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?


Sheeloo[_2_]

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