convert email address file in Excel 2000 to Word file with commas

[Mike A.]

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.

 

[Barb Reinhardt]

When you paste into excel, did you try to Paste Special -> Unformatted text?

 

[Sheeloo]

Assuming you have your addresses in Col A in Excel

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...

 

[James Silverton]

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:

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

 

[James Silverton]

James wrote to Sheeloo on Mon, 13 Oct 2008 13:27:45 -0400:

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) --

Sorry, that should have been (comma space) of course.

--

James Silverton
Potomac, Maryland

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

 

[Mike A.]

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

 

[Mike A.]

Hello Barb,

You misunderstood.

I want to transfer a column of email addresses on Excel through copy and
paste into a Word file. Subsequently, I wish to copy and paste the Word file
into an email on MSN Hotmail and send. Thanks for your help. I am using
Office 2000. You can respond directly if you wish to: (e-mail address removed)

 

[Bob I]

Paste it into Notepad NOT Word. That will remove the formatting that is
causing you problems

 

[James Silverton]

Mike wrote on Tue, 14 Oct 2008 02:24:00 -0700:

I tried your formula and it worked to an extent, keeping all

Let me repeat my somewhat abbreviated instructions. Suppose there are a
lot of email addresses in column A of a spreadsheet.I'm using an older
Excel 2002 too.

1. Select the addresses or column A.
2..CTRL-C to copy
3.Open Word document and click copy position
4.Edit>Paste Special>Unformatted text>OK
5. Select the addresses
6.Edit>Find what ^p>Replace with , {put a space after the comma}>Replace
All>OK

In case of transmission glitches, "^p" is carat lower case "p" and I
just tried it and only the last address needs the comma removed.
--

James Silverton
Potomac, Maryland

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