On 5 May 2006 08:04:07 -0700, "Weber1" wrote:

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
__________________________