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 I’ve 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?

date: Fri, 26 Sep 2008 21:12:00 -0700   author:   bgsignal

RE: 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 I’ve 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?

date: Fri, 26 Sep 2008 21:20:01 -0700   author:   Sheeloo

RE: 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 I’ve 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?

date: Fri, 26 Sep 2008 21:21:00 -0700   author:   Sheeloo