Pablo

Not entirely correct.

Excel will allow 32,767 characters to be entered in a cell.

The kicker is that only 1024 of these will be visible.

You can squeeze more in if you use the ALT + ENTER as Frank suggests.

Using a smaller font will also get more visible.

Gord Dibben Excel MVP

On Mon, 27 Dec 2004 09:13:56 -0800, "Pablo Picasso"
wrote:

Excel limits the number of characters that can be input in to a cell, if you
are over 1024 characters in the cell, it will not allow you to enter more.
You may want to consider creating a table in Word, or migrate your worksheet
to Access and create a memo field.

"pearsms" wrote:

I can only make the first 10 lines wrap within one cell and the rest will not
wrap appropriately. Any solution to wrap more than 10 lines of text per cell?