Excel to Word problem: advice please?

Is there some way of exporting text from Excel spreadsheet into plain text format? I have a database of contacts in Excel and want to take all the email addresses out (they're all in one column) and put them in a plain text format so I can then copy and paste all the email addresses in one go into the 'to' box when sending emails.


Don't tell me to keep them in the Outlook address book: i use Excel so that I can store all sorts of other information on my work contacts too.Excel to Word problem: advice please?
Hey SLF,





From the Spreadsheet, do file save as. Select a Text type of file form the drop down list of File types. There are Tab delimited, MS DOS and Unicode text types. I would either use the Tab or MS DOS. The new file name will be 'name.TXT'





Open the word program and pick .TXT type in the File Open dialog box. Select the 'name.TXT' file you exported.





The other way to do this is simply highlight the area in the Excel spreadsheet you want to put in Word. Copy the Cells with the COPY Menu or Right Click options. Go to the word document an perform an EDIT - PASTE SPECIAL - unformatted text.Excel to Word problem: advice please?
Years of experience. Lots of needs to do similar things. Glad to help.

Report Abuse

Try this. Copy and paste the column you want from Excel into a word document. Then highlight the column in the Word document. Click on ';Table'; drag down to ';convert'; Click on ';Table to Text.'; It will ask you what to put in between the fields. Use a comma if you want to send an email.
You can copy and paste selected rows or columns from an Excel spreadsheet into a Word document in the form of a table.





Then you can convert the table to text (it's a choice under the ';table'; menu) and save the document as a .txt file.





Depending on how you have your spreadsheet formatted, you may need to do quite a bit of text editing to get things organized as you want them. But some experimentation and tinkering will surely pay off for you.





Another approach is to use the MailMerge functionality in MS Word. It is very sophisticated and beyond the scope of a message like this to explain, but the help is pretty thorough. Basically, in MailMerge, you can produce multiple documents with text insertions using an Excel spreadsheet directly as the data source.





If that will meet your needs it may be the simplest approach. Best of luck!
Copy the column from excel


Use Edit%26gt;Paste Special in word and select unformatted text