MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text cut off in cell


Posted by Dale on June 26, 2001 9:26 AM

HELP ME! I seem to hit a wall in the amount of text that will appear or print in a cell. I haven't counted every character, but at somewhere around 1200 characters the screen won't display the rest of the text. And even if I widen the column to get it all to show, when I print the text gets cut off, and no amount of manipulation gets it to print. How do I get a cell to display and print unlimited text??? Please, any assistance would be greatly appreciated!


Posted by Tom Morales on June 26, 2001 11:25 AM

Dale - Sadly, you've banged your head against one of Excel's limits. You can have up to 32,767 characters in a cell, but only 1,024 display in that cell. By way of consolations, all 32,767 display in the formula bar.

You also have a limit in row height, 409 points.

Tom

Posted by Dale on June 26, 2001 1:07 PM

Thank you! Believe it or not, I'm relieved. I thought I just didn't know how to format a cell!! I guess I'll have to edit the text to keep it below 1024. Thanks again!

Posted by IML on June 26, 2001 1:51 PM

Before you start a cut and paste fest, you may want to play around with formulas such as
=LEFT(A1,1024)
=MID(A1,1025,1024)
etc.
You can then copy paste special values over them.

good luck.