Importing MS Word table to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RITCHI - 27 Feb 2007 21:56 GMT

Hi

I have a table in word that I need to import into Excel so that the
content of each cell in the table is posted into a matching cell in
Excel; i.e, the contents of a table cell are not split/entered into
multiple cells in Excel.

Any help would be gratefully received.

Ritchi

Reply to this Message

Earl Kiosterud - 28 Feb 2007 00:51 GMT

Ritchi,

First, try opening the document in Word, selecting and copying the table, then pasting it
into Excel. When you paste, select only the upper-right-hand corner cell where you want it
pasted, and be sure there are plenty of empty cells below and to the right.

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> Hi
>
[quoted text clipped - 6 lines]
>
> Ritchi

Reply to this Message