View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_3_] James Silverton[_3_] is offline
external usenet poster
 
Posts: 119
Default convert email address file in Excel 2000 to Word file with commas

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

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


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

--

James Silverton
Potomac, Maryland

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