How to convert a huge table in MS word to MS excel

Hi,

I have a huge table in MS word. It has 10 columns and over 2000 rows. I wish
to convert this to excel. How to do this without loosing the integrity of the
data.

I tried to do copy an dpaste but then my table looses its integrity. Some
times 2 or more cells (in excel) appear to contain what was contained in 1
cell in word.

Kindly help.

Thanks
Rum

It the Word table cells contain tabs, line breaks, or returns, they ( the
tabs, etc.) can cause two or more cells in Excel. I transfer tables from
Word to Excel (and the other way) fairly often but not often enough to
figure out why the behavior changes. So I'll just suggest that you try
regular paste and paste special, unformatted text. One or the other often
works. For more complex large tables, I have copied and then proofed, a
section at a time.

Pam

Rum wrote:
>Hi,
>
>I have a huge table in MS word. It has 10 columns and over 2000 rows. I wish
>to convert this to excel. How to do this without loosing the integrity of the
>data.
>
>I tried to do copy an dpaste but then my table looses its integrity. Some
>times 2 or more cells (in excel) appear to contain what was contained in 1
>cell in word.
>
>Kindly help.
>
>Thanks
>Rum

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-tables/200909/1