32,767 characters can be in a cell; 1,024 display in the cell; all 32,767
display in the formula bar. You could try to trim any blanks at the end of
the text, =trim(cell reference), or you could try putting in a hard line
break before the last line -- altenter. HTH

Sincerely, Michael Colvin


"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?