ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   limit on cell contents (https://www.excelbanter.com/excel-programming/357471-limit-cell-contents.html)

tina

limit on cell contents
 
In Excel Help, it says that the...Length of cell contents (text) is limited
to 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

I need to be able to print all contents in a cell. Is there a way to do
this by getting around this cell limitation?

Thank you!
--
Tina

Tom Ogilvy

limit on cell contents
 
If you put in hard character returns within the test string (alt+Enter)

you can get more then 1024 to display. In conjunction with that, you can
reduce the font size as well if you are running up against the maximum size
of the cell.

--
Regards,
Tom Ogilvy


"Tina" wrote:

In Excel Help, it says that the...Length of cell contents (text) is limited
to 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

I need to be able to print all contents in a cell. Is there a way to do
this by getting around this cell limitation?

Thank you!
--
Tina



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

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