Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I convert tables in a Word document to an Excel worksheet?
how can I convert a Word document consisting mostly of tables into an Excel
format? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I convert tables in a Word document to an Excel worksheet?
"miraccav" wrote:
how can I convert a Word document consisting mostly of tables into an Excel format? You can try pasting the content of the Word document in Excel. If the document is well structured and there are no merged cells in your tables, it should be OK. But to be safe, you should paste each table one by one and see what Excel does with each table. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I convert tables in a Word document to an Excel worksheet?
On Fri, 22 Feb 2008 09:12:02 -0800, miraccav
wrote: how can I convert a Word document consisting mostly of tables into an Excel format? You can select an entire Word table (click in the table, then Table Select Table, or click the little square with four arrowheads that appears at the top left corner), copy it to the clipboard, and paste it into Excel. It will automatically be separated into cells. Non-table material doesn't behave so nicely -- it just drops into a single cell. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I convert tables in a Word document to an Excel worksheet?
Although if the content contains common delimiters, such as a tab or
paragraph mark, it will separate the data. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP https://mvp.support.microsoft.com/profile/Melton What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs "Jay Freedman" wrote in message ... Non-table material doesn't behave so nicely -- it just drops into a single cell. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink in Excel Worksheet to a word folder not a document | Microsoft Word Help | |||
Problem printing Word document with embedded Excel worksheet | Microsoft Word Help | |||
Word Document Merge and MS Excel Worksheet via DDE | Microsoft Word Help | |||
how to insert and excel worksheet into a word document? | Microsoft Word Help | |||
Macro to Convert All Embedded Excel Tables to Text | Tables |