Character limit per cell
 

Appologies if this has already been covered.

Why, when the limit on number of characters per cell in Excel 97 is 32,767,
can't I get it to display or print more than approx 1,150 characters,
although I've wraped the text and the cell width and height are ok?

Thanks in advance,
Brian

Add a few manual (forced) line-breaks periodically throughout the text at
relevant places,
<Alt <Enter

This will give you more displayed text.
--

HTH,

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

"BrianR" wrote in message
...
Appologies if this has already been covered.

Why, when the limit on number of characters per cell in Excel 97 is 32,767,
can't I get it to display or print more than approx 1,150 characters,
although I've wraped the text and the cell width and height are ok?

Thanks in advance,
Brian

RD
Thanks, that's solved it.

Regards,
Brian

"RagDyeR" wrote in message
...
Add a few manual (forced) line-breaks periodically throughout the text at
relevant places,
<Alt <Enter

This will give you more displayed text.
--

HTH,

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

"BrianR" wrote in message
...
Appologies if this has already been covered.

Why, when the limit on number of characters per cell in Excel 97 is
32,767,
can't I get it to display or print more than approx 1,150 characters,
although I've wraped the text and the cell width and height are ok?

Thanks in advance,
Brian

From MY experience the solution of usint Alt&Enter still only allows there
to be about 1040 visible characters in a cell.

I have some time messing about with this and have not found any direct link
but the visible cells is effected also by the column width.

Below is a reply from Gord to demonstrate the lack of logic to this:-

Andi

Been playing with this and find the following, which is no help to you.

Enter =REPT(REPT("1234567890",12)&CHAR(10),30)

Gives 30 lines of 120 characters in the cell = 3630 chars(including the
CHAR(10)'s

Wrap text is set.

Column width at 121

FormatRowAutofit shows 17 lines = 2040 characters

Column width at 136

FormatRowAutofit shows 9 lines = 1080 characters plus whitespace.

Manually fit row height and can see all 3630 characters.

Not much rhyme nor reason as far as I can see.


Gord


"RagDyeR" wrote in message
...
Add a few manual (forced) line-breaks periodically throughout the text at
relevant places,
<Alt <Enter

This will give you more displayed text.
--

HTH,

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

"BrianR" wrote in message
...
Appologies if this has already been covered.

Why, when the limit on number of characters per cell in Excel 97 is 32,767,
can't I get it to display or print more than approx 1,150 characters,
although I've wraped the text and the cell width and height are ok?

Thanks in advance,
Brian