Limit to Text in Excel Cell

A

Al Franz

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?
 
B

Bernard Liengme

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
 
D

Dave Peterson

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.
 
A

Al Franz

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

Thanks for the help.
 
G

Guest

I have the same question.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel can't display the text in one cell right if it's big 1
XL2003: why does word wrap stop wrapping? 4
Wrapping Text in Merged Cells (from Word into Excel) 1
Exceed text limit in a merged cell 3
Word Wrap in Cell Stops??? 3
Populate cell with multiple non-blank text values 3
hanging indent in a cell 2
cell does not auto-stretch when too much text in one cell 2

Top