Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert email address file in Excel 2000 to Word file with commas
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert email address file in Excel 2000 to Word file with commas
When you paste into excel, did you try to Paste Special - Unformatted text?
-- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert email address file in Excel 2000 to Word file with commas
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... "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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert email address file in Excel 2000 to Word file with commas
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert email address file in Excel 2000 to Word file with com
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: "Barb Reinhardt" wrote: When you paste into excel, did you try to Paste Special - Unformatted text? -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert email address file in Excel 2000 to Word file with com
Paste it into Notepad NOT Word. That will remove the formatting that is
causing you problems Mike A. wrote: 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: "Barb Reinhardt" wrote: When you paste into excel, did you try to Paste Special - Unformatted text? -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert email address file in Excel 2000 to Word file with com
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.EditPaste SpecialUnformatted textOK 5. Select the addresses 6.EditFind what ^pReplace with , {put a space after the comma}Replace AllOK 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert an address file from Word into Excel? | Excel Worksheet Functions | |||
File Convert With commas to txt format | Excel Discussion (Misc queries) | |||
how to convert word file to excel file | New Users to Excel | |||
how to convert word file into excel file | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) |