Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
convert to worksheet
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
convert to worksheet
That depends on the format of the word document.
-- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "nick" wrote in message ... 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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
convert to worksheet
nick wrote:
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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I convert tables in a Word document to an Excel worksheet? | Tables | |||
Mail merge from more than one XL worksheet | Mailmerge | |||
How do I e-mail an excel worksheet? | Microsoft Word Help | |||
Can I use more than 1 worksheet to merge info | Mailmerge | |||
Merge via worksheet converter | Mailmerge |