Hello James,

I tried your formula and it worked to an extent, keeping all the email
addresses in a column followed by a comma in MS Word. But when I tried to
copy and paste 20 or so addresses into an email letter using MSN Hotmail, it
did not work. Can you take me one step further to accomplish my goal? That
is, I want to convert a column of email addresses on Excel into a Word file
that I can copy and subsequently paste into an email on MSN Hotmail and send.
Thanks for your help. Again, I am using Office 2000. You can send directly
if you wish to:

"James Silverton" wrote:

Sheeloo wrote on Mon, 13 Oct 2008 10:03:02 -0700:

Enter this in B1
=A1&","
and copy down to the last row with address in A

Select Col B

Open Word document

Choose Edit|Paste Special|Unformatted Text

You will get a list of addresses with "," at the end.

If you want them in one line in Word then do this

--
To get my email id paste my address in an Excel cell and press
Enter... Enter this in B1
=A1&","
Enter this in B2 and copy down
=B1&A2&","

Select the last cell only and paste in word...

"Mike A." wrote:

I wish to convert a colum file of email addresses in Excel to
a Word file with a comma after each address? I copy in Excel
but the cell/chart structure is maintained when I paste into
Word. What should I do? The purpose is to email address
books.

Another and similar way is not to convert in Excel, copy, Paste Special
in Word and then replace all ^p (paragraph mark) with , (space comma)
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not