how do you turn an email address list into an Excel csv or txt file?

[Weber1]

Hi, all--I'm a novice, so forgive me if this is a ridiculously simple
question: I have an email list in Word that consists of email
addresses, in which each address is separated by a comma. I would like
to convert it to an Excel file, specifically a csv. or txt. file in
which each email address will occupy its own row. I want to end up
with a long row going down column A consisting of email addresses. Can
anyone enlighten me as to how to do this? Many thanks, Weber1

 

[Don Guillett]

One way would be to use data>text to columns and then transpose. or a macro.

 

[Richard Buttrey]

Hi, all--I'm a novice, so forgive me if this is a ridiculously simple
question: I have an email list in Word that consists of email
addresses, in which each address is separated by a comma. I would like
to convert it to an Excel file, specifically a csv. or txt. file in
which each email address will occupy its own row. I want to end up
with a long row going down column A consisting of email addresses. Can
anyone enlighten me as to how to do this? Many thanks, Weber1

What does the data in word look like, and how many names in a

name1,name2,name3

or

name1,
name2,
name3,

etc.,

or

name1,name2,name3
name4,name5,name6

In general, one technique would be to get all the names into a single
row in Excel, then use Data-->Text to Columns to split the individual
names into separate columns, then if you want the names arranged
vertically in a single column, use Range-->Transpose.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Weber1]

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. (e-mail address removed), (e-mail address removed), (e-mail address removed), (e-mail address removed)
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.

 

[Richard Buttrey]

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. (e-mail address removed), (e-mail address removed), (e-mail address removed), (e-mail address removed)
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
__________________________

 

[Weber1]

Thanks. When I opened a new worksheet and did the "paste special" and
then transpose-it worked!--W.