View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default how do you turn an email address list into an Excel csv or txt file?

One way would be to use datatext to columns and then transpose. or a macro.

--
Don Guillett
SalesAid Software

"Weber1" wrote in message
oups.com...
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