ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   text (3750 char.)truncates with text wrap and row heigh adjusted? (https://www.excelbanter.com/excel-discussion-misc-queries/26866-text-3750-char-truncates-text-wrap-row-heigh-adjusted.html)

Boydster

text (3750 char.)truncates with text wrap and row heigh adjusted?
 
when text in a cell exceeds a certain amount it truncates and will not wrap
below even when row height is adjusted. Anybody know why or how to fix it?

Peo Sjoblom

Look in help for specifications, there you will see that the stated limits of
characters to disply in a cell are 1024 characters, that can be overcome
somewhat by using a lot of new lines added with alt + enter, don't know how
many more? You can also use a text box


Regards,

Peo Sjoblom

"Boydster" wrote:

when text in a cell exceeds a certain amount it truncates and will not wrap
below even when row height is adjusted. Anybody know why or how to fix it?



All times are GMT +1. The time now is 01:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com