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

The current maximum is about 1,100.

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

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.

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

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.

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

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.

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

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

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

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.