How can I increase the character capcity of an Excel cell?

J

Jim Rech

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

RagDyer

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!
==============================================
 
M

Mark Johnstone

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
 
D

Dave Peterson

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

RagDyeR

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 !
----------------------------------------------------------------------------
-------------------

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
 
Top