linking to Word, maintaing word-wrap

I've been experimenting with linking and embedding short Word
documents in Excel to get around Excel's limit on the number of
characters llowed in a cell.

I would prefer to link, rather than embed, but it seems that linking
basically captures the Word document as a graphic: I've seen it respect
the line-breaks in the original Word document, and when I try to
stretch the block of text in Excel to match the width of the
spreadsheet above, the text distorts instead of rewrapping.

Is there anyway around this, other than experimenting and settling on a
line-length to use in the separate Word document that will sit nicely
when linked into the Excel spreadsheet?

You could use a text box from the Drawing toolbar, instead of embedding
a Word document.

Kevin wrote:
> I've been experimenting with linking and embedding short Word
> documents in Excel to get around Excel's limit on the number of
> characters llowed in a cell.
>
> I would prefer to link, rather than embed, but it seems that linking
> basically captures the Word document as a graphic: I've seen it respect
> the line-breaks in the original Word document, and when I try to
> stretch the block of text in Excel to match the width of the
> spreadsheet above, the text distorts instead of rewrapping.
>
> Is there anyway around this, other than experimenting and settling on a
> line-length to use in the separate Word document that will sit nicely
> when linked into the Excel spreadsheet?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html