General discussion

Locked

passing word doc. to excel

By lacalaca ·
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

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by ReWrite In reply to passing word doc. to exce ...

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

Collapse -

by lacalaca In reply to

Poster rated this answer.
Thank you.

Collapse -

by ReWrite In reply to passing word doc. to exce ...

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

Collapse -

by lacalaca In reply to

Hi, sorry I did not answer back before.
Ok I'll try that.
Thank you

Collapse -

Posting a Word Document in an Excel Spreadheet

by doug In reply to

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.

Collapse -

by DKlippert In reply to passing word doc. to exce ...

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

Collapse -

by lacalaca In reply to

you mean, from word I just copy and paste?.
ok, I'll give it a try.
thank you

Collapse -

by lacalaca In reply to passing word doc. to exce ...

This question was closed by the author

Back to Software Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums