From Help on Specifications you will find that 32767 characters can be entered
in a cell.

However, only 1024 of these will be seen or can be printed.

To get around this 1024 limit follow RD's advice and sprinkle some AT +
ENTER's in every 1000 chars or so.

Postings have indicated that you can increase the 1024 up to several thousand.

Another work-around is to use a Text Box to store the text.


Gord Dibben Excel MVP

On Mon, 9 May 2005 11:36:28 +1200, "Althea" wrote:

Dear list
A general question, I am typing larger amounts of info in a single cell and
it gets to a stage where it is not displayed, even when I choose "wrap
text". What is the maximum size of text for a cell?
Many thanks
Althea