Copying a table from Word 2000 to Excel 2000

[Mike]

I am having a problem with formating when I copy a table
from a word document into excel. Someone in my company
decided to use Word to make a very large table. As this
is fairly useless to us in Word format, I am trying to
port it over to Excel. The problem is in how Excel
formats the table. In Word, some of the cells of the
table have multiple groups of text seperated by a blank
line within the same cell. (Basically paragraphs). When
it is copied into excel each of these paragraphs becomes
its own cell instead of the paragraphs being in one cell
as they are in the Word table. So, my question is, is
there anyway to copy it over without it making all these
extra cells in the excel format. As it is, I have been
copying and pasting from the seperate paragraph cells
into one cell. This is obviously very tedious. Any help
is appreciated.

 

[Paul Falla]

Dear Mike

Select the entire Word table, and copy it. Move to the
relevant insertion point in Excel and then Edit/Paste
Special/Unicode Text.

That should do the trick.

Hope this helps

Paul Falla