On 7 May 2006 12:27:48 -0700, "Weber1" wrote:
Thanks for replying Richard and Don. As far as what kind of Word file,
it's just a Word document page that contains the addresses one after
another ie. , , ,
It just goes on and on with no breaks. When I tried to paste it into
Excel it placed all the text (that is, all the email addresses) into a
single cell.
Ah, OK
This works for me.
First save the Word file as a plain text (*.txt) file.
Then open the file in Excel and choose the 'delimited option with the
comma as the delimiter.
This will bring all the records into different columns. Then select
all the columns of data and Edit ----Copy then Edit ---?PasteSpecial
Transpose.
That should leave you with all the addresses listed in a single
column.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________