The current maximum is about 1,100.

Excel can hold 32k characters of text and around 1000 in a formula. You
can't change this fact of life.

--
Jim
"Steve" wrote in message
...
| The current maximum is about 1,100.

You can increase the ability of the cell to *display* more characters (cell
can *contain* approx. 32,000) by strategically inserting forced line breaks
(<Alt <Enter) within the text.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steve" wrote in message
...
The current maximum is about 1,100.

Do you know how you can get the entire contents of the cell to print. I have
added the forced line breaks, but the contents still don't display in full
because of the limitation in row height within Excel (409).

I can only get the displayed characters to print.

Thanks

Mark

"RagDyer" wrote:

You can increase the ability of the cell to *display* more characters (cell
can *contain* approx. 32,000) by strategically inserting forced line breaks
(<Alt <Enter) within the text.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steve" wrote in message
...
The current maximum is about 1,100.

Have you tried widening that cell's column? Changing to a smaller font?

Just curious...How many characters are in that cell?

Something like
=len(a1)
should help you answer.



Mark Johnstone wrote:

Do you know how you can get the entire contents of the cell to print. I have
added the forced line breaks, but the contents still don't display in full
because of the limitation in row height within Excel (409).

I can only get the displayed characters to print.

Thanks

Mark

"RagDyer" wrote:

You can increase the ability of the cell to *display* more characters (cell
can *contain* approx. 32,000) by strategically inserting forced line breaks
(<Alt <Enter) within the text.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steve" wrote in message
...
The current maximum is about 1,100.



--

Dave Peterson

I'd be really interested in your answer to Dave's question, since I've
personally been able to display more then 5,000 characters.


Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Mark Johnstone" <Mark wrote in message
...
Do you know how you can get the entire contents of the cell to print. I have
added the forced line breaks, but the contents still don't display in full
because of the limitation in row height within Excel (409).

I can only get the displayed characters to print.

Thanks

Mark

"RagDyer" wrote:

You can increase the ability of the cell to *display* more characters
(cell
can *contain* approx. 32,000) by strategically inserting forced line
breaks
(<Alt <Enter) within the text.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steve" wrote in message
...
The current maximum is about 1,100.