You can't retain the Word formatting that way, though you could enable text wrapping within Excel. Moreover, a document that's got complex formatting (e.g. numbered, bulleted, indented, justified paragraphs) would be totally screwed up for copy/paste purposes by what you're suggesting. Perhaps you should consider pasting the document into Excel as an embedded object.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

It will retain the same formatting using a discrete paragraph for each line. Inserting the word document as an embedded object does not populate any cells. Instead it is just a floating block.

The purpose of this is to use excel to quickly draw a table in Revit with notes formatted in Word. Unfortunately Autodesk has not made Revit friendly to bringing in large blocks of notes from Word.

If there is a simple code for my original post please let me know.

There isn't simple code for your original post request. All hanging indented content you add paragraphs in will completely look different and if bulleted or numbered then that would end badly. You would use soft returns (line breaks) rather than paragraph marks to avoid that issue but the result is only marginally better.

I still don't see the problem, if I copy Word content and go to Excel and choose Paste Special > Microsoft Word Document Object (as you said you are doing) then the content appears with the same line wraps that the Word document had.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia