You can see lots more than those 1024 characters if you add alt-enters every
80-100 characters.

bigwheel wrote:

See "Worksheet and workbook specifications" in the help file. 32,767 is the
maximum of which only 1,024 will display in a cell. Wouldn't it be simpler
to put your text in a text box?

"Frustrated" wrote:

I have a cell in a row that has approximately 300 characters, and the last
line in the text will not wrap nor will the row adjust to the text. How do I
adjust the text and the row. I've tried everything (autofit, copying the
text to new sheet, manually adjusting the row), nothing seems to work. Is
there a limit to the number of characters a cell can hold?

--

Dave Peterson