Hi Shauna and Angela... I am having the exact same problem. I need to paste
a Word table into Excel, where the cells contain paragraph markers, and I
need the cells in Excel to look exactly like they do in Word. Did you ever
get a response from anyone on the Excel newsgroups? I have posted this
question out there today but then ran across your thread below... thanks,
Steve

"Shauna Kelly" wrote:

Hi Angela

There are things that Word can do in a table that Excel can't do. And there
are things that Excel can do that Word can't do. So when we copy a table
from Word to Excel, Excel does its best and interprets what you paste in its
own way. It is particularly unforgiving if you had more than one paragraph
in a cell in Word, or if you used New Line breaks in a cell in a Word table.
Excel will interpret each paragraph or each line to be a separate cell. And
it will merge adjacent cells to try to replicate Word's formatting to some
extent.

However, there may be some ways to format your Excel spreadsheet the way you
want it. Post a question to one of the Microsoft Excel newsgroups. Let them
know what you are seeing in Excel and what you would like to see.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Angela" wrote in message
...
I've got a table I've created in Word 2002 and I'd like to export it or
paste
it into an Excel spreadsheet. When I paste the copied table into Excel
the
formatting displayed is incorrect. In Word for example I've got a a row
that
contains 15 line in this one record. When I paste it into Excel, Excel
sees
those lines individually and creates a row for each. Is there a simple
way
to transfer this table to Excel and still maintain all the formatting?
Any
help you could offer would be greatly appreciated. Thank you in advance.
--
Angela