Limit to Text in Excel Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al Franz - 13 Dec 2005 22:25 GMT

Is there a limit to the amount of text you can have in a cell? After about
20 lines the word wrap stops wrapping text. Is this adjustable?

Reply to this Message

Bernard Liengme - 13 Dec 2005 22:36 GMT

From Excel's Help (search 'specifications')
Length of cell contents (text)
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

Sounds like you should be using a text box
best wishes

Signature

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

> Is there a limit to the amount of text you can have in a cell? After
> about 20 lines the word wrap stops wrapping text. Is this adjustable?

Reply to this Message

Al Franz - 14 Dec 2005 17:25 GMT

I guess the displaying 1024 characters is my problem. Surprised it is so
small.

Thanks for the help.

> From Excel's Help (search 'specifications')
> Length of cell contents (text)
[quoted text clipped - 5 lines]
>> Is there a limit to the amount of text you can have in a cell? After
>> about 20 lines the word wrap stops wrapping text. Is this adjustable?

Reply to this Message

Dave Peterson - 13 Dec 2005 22:49 GMT

If you add alt-enters (to force new lines within the cell) every 80-100
characters, you can see lots more than the documented number of characters.

> Is there a limit to the amount of text you can have in a cell? After about
> 20 lines the word wrap stops wrapping text. Is this adjustable?

Signature

Dave Peterson

Reply to this Message

jrc - 13 Feb 2006 20:37 GMT

I have the same question.

Sure, there are workarounds, but does anyone know the answer to the original
question?

> Is there a limit to the amount of text you can have in a cell? After about
> 20 lines the word wrap stops wrapping text. Is this adjustable?

Reply to this Message

Pete_UK - 13 Feb 2006 21:12 GMT

Bernard's reply to the original posting answers it - 32,767 characters.

Pete

Reply to this Message