Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |