Cell/text formatting
 

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?

Add alt-enters every 80-100 characters to force new lines within the cell.

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

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?

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?

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