ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   maximum number of letters which can be entered in excell shell (https://www.excelbanter.com/excel-worksheet-functions/76918-maximum-number-letters-can-entered-excell-shell.html)

Helena March 13th 06 02:08 PM

maximum number of letters which can be entered in excell shell
 
How long can be the text entered in the excell shell? I have quite long text
and only approximately 3/4 of the text is printed out

Bernard Liengme March 13th 06 10:17 PM

maximum number of letters which can be entered in excell shell
 
I assume SHELL is typo for CELL

In Help search for SPECS (specifications) and you will find
Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.


best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Helena" wrote in message
...
How long can be the text entered in the excell shell? I have quite long
text
and only approximately 3/4 of the text is printed out





All times are GMT +1. The time now is 09:33 PM.

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