Pasted Text Truncated?

A

AJ

I'm trying to copy/paste some text from a Word document into a single Excel
cell in worksheet that was created by someone else.

The text has about 250 words/about 600 characters or so. There are about 5
major points, each point has about 4 bullet points underneath it. There's
about 25 lines of text. I've formatted the cell to wrap text, but the last
20 words or only display if I expand the width of the entire column - which
makes the other cells in that column much too wide - and the page won't
print as it should (a single page).

When I increase the length of the row it still doesn't show any more of the
text - which seems odd since it will show all of the text when I increase
the width of the column.

To keep the cell to a reasonable height and width, I've resorted to copying
the paragraph as an object and that works - but the downside is that I have
an outline surrounding the text.

Any ideas why this text won't paste and wrap properly? Suggestions?

Thanks.....AJ
 
B

BoniM

Excel limits:
Column width 255 characters
Row height 409 points
Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

Right click on the paragraph object... choose format... and on the colors
and lines tab change the line color to no line to remove the outline.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top