nick said:
Is there a way to convert a word document into an excel worksheet
or a way to convert an ordinary word document into a word table?
Thanks
There are ways to do both.
First, make sure each piece of text that will become a row ends with a
paragraph mark (if you click the ¶ button, you should see the ¶ symbol at
the end of every row).
Choose a particular character to separate the columns in each row. That's
often a tab character, but you can also choose commas, semicolons, the
vertical-bar or pipe character (|), or just about anything else that doesn't
appear in the "real" text.
Select all the text that should become a table. In Word 2003 or earlier,
click Table > Convert > Text to Table. In Word 2007, click the Insert
ribbon, click the Table button, and choose Convert Text To Table from the
menu.
In the dialog that appears, select the correct separator character for the
columns. If it isn't commas or tabs, type the character into the Other box.
Make sure the correct numbers of columns and rows are shown in the top of
the dialog; if they're wrong, you probably don't have the same number of
items in each row, and you should fix that before proceeding.
When you click OK, the text will be put into a table and the separator
characters will be removed.
If you need the information in Excel, just copy the table to the clipboard
and paste it into a worksheet. The other way is to use commas for the
separators, don't create the table, and save the Word document as a plain
text file with a .csv extension (for "Comma Separated Variables"), which you
can then open in Excel, but that's more work just to get the same result.
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
