ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Convert Word Table to Excel Spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/4137-convert-word-table-excel-spreadsheet.html)

[email protected]

Convert Word Table to Excel Spreadsheet
 
I know how to use the mail merge feature from Excel to Word, but how
about from existing labels in Word to a usable Excel spreadsheet. My
approaches have been to save word as .txt and then get external data in
Excel. That works great accept I need to be able to have different
column fields like Name, Address, City, State etc. What is the best way
to go about doing this?
Any help?? Thank you in advance.


Bernard Liengme

Have you tried Copy and Paste?
You may need to play with cell borders if the borders show in the Word doc.

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
I know how to use the mail merge feature from Excel to Word, but how
about from existing labels in Word to a usable Excel spreadsheet. My
approaches have been to save word as .txt and then get external data in
Excel. That works great accept I need to be able to have different
column fields like Name, Address, City, State etc. What is the best way
to go about doing this?
Any help?? Thank you in advance.





All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com