The wrap text feature stops after 10 - 12 lines.
 

I'm trying have a large text field in an excel file. After about 10 - 12
lines the text no longer wraps. My Excel book said each cell holds about
32,000 characters, my text is less than 2,000 characters (with spaces). Any
ideas?

The wrap text feature stops after 10 - 12 lines.
 

The Excel book is right......you can enter 32,767 characters in a cell.

What the book did not explain is that only 1024 or those characters can be seen
or printed.

Stick in an ALT + ENTER(carriage return) about every 100 characters and you can
expand the 1024 limit by at least 4 or 5 times.


Gord Dibben MS Excel MVP

On Fri, 13 Jan 2006 12:43:02 -0800, "STLVicki"
wrote:

I'm trying have a large text field in an excel file. After about 10 - 12
lines the text no longer wraps. My Excel book said each cell holds about
32,000 characters, my text is less than 2,000 characters (with spaces). Any
ideas?