Software

Ask something
Discussion Locked

passing word doc. to excel

0 helpful
8 replies

by lacalaca

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, i have a list in a word 2003 document, it is a numbered list in one column and I want to pass it to excel .
What will it be the way to go.
Thank you

8 replies

by rewrite

Either link or embed the word document into the spreadsheet. Go to the excel help file and search for "import word document" or similar for instructions.

Cheers.

RW

by rewrite

If you want to import the document into excel you cannot do it directly. The doc format has formatting info imbedded into it that excel will be confused with. To import a word document, open the document in ms word and save it as a text document. You can then import it into excel using the data->get external data menu option.

Cheers.

RW

by doug

Embedding a word Document is a simple process - the process is to "Insert" an object. In the object selection box, Select the "Create from File" tab then check the "Display as icon" check box. Now click the browse button and navigate to and select the word document you wish to embed, click "Insert" and then click "OK".

The document will open in Word when you doble click the Icon in the spreadsheet (as long as you have Word loaded).

You can use this method for different type objects, word pad fies, text files, Adobe pdf files, media clips and much more.

Don't check the the "Display as icon" check box if you want to see the document in the spreadsheet instead of seeing an Icon.

by dklippert

You can copy and paste into Excel.
You can also use Paste Special to make it a linked object.

This discussion is closed to new replies.