how much is too much data for a cell?

[evilyn]

a cell should hold 32,000 characters if i am not mistaken. i have a
large spreadsheet that has codes, their use, description and the # of
times they have been 'hit'. most of the information fits in a cell
very easily but i have one description that is huge. i made the cell
255x409 which is the max and what happened was part of the information
showed and then the rest of the cell was blank. at that cell size
there was more than enough room for all the data but for some reason
it would not all show. i tried things like changing the alignment and
it is on wrap text. i tried selecting all the data and making it a
different smaller font. but nothing seems to work. its probably a
simple fix but...too complicated for me obviously. i have the excel
2003 bible but couldn't find my answer in there either. any and all
help is greatly appreciated.

 

[Peo Sjoblom]

It will not show in the cell beyond 1024 but it will in the formula bar.

--


Regards,


Peo Sjoblom

 

[RagDyer]

I don't know the exact number of characters that will actually display, but
I've been able to get over 5,000 to show by placing forced line breaks (
<Alt> <Enter>) at appropriate places throughout the text.

 

[evilyn]

Thanks. I'll try that.

I don't know the exact number of characters that will actually display, but
I've been able to get over 5,000 to show by placing forced line breaks (
<Alt> <Enter>) at appropriate places throughout the text.
--
HTH,

RD

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






- Show quoted text -

 

[RagDyer]

Appreciate the feed-back.

Would also appreciate your max character count with this procedure if in
excess of 5,000.

 

[Gord Dibben]

RD

.........From Dave Peterson..........

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................


Gord

 

[RagDyer]

Thanks Gord.

Too lazy to do something like that myself.
I wonder ... what really is the max?

Just like Dana and Harlan got together in a thread and found out the real
max for sheets in a WB is 5,447.

I guess you need a certain "drive" to get into all that testing stuff.<bg>

 

[Gord Dibben]

Speaking of Harlan. He posted posted this July 9, 2003

Quoted.....................

FWIW, XL2K displays all 11,804 chars of

="foo"&CHAR(10)&REPT(REPT("----+----#",25)&CHAR(10),47)&"bar"

both as a formula and converted to a text constant. Granted this is at 6
point typesize, cell width 172, height 409.5, screen resolution 1280x1024,
and with word wrap enabled. Still. makes a bit of a mockery of this 'spec'.

End quote.......................

Also in another Harlan post August 13, 2003.................

At 1024 by 768 resolution, with column width 139 (visible width of Excel
document window while still showing worksheet frame and vertical scroll bar)
and row height maxed out at 409.5, with word wrap enabled, and font Times
New Roman at 4 point typesize, Excel 2K (at least) happily displays all
15,751 characters of the formula

=REPT("-",480)&CHAR(10)&
REPT(" > "&REPT("#",246)&" < "&CHAR(10),58)&REPT("-",480)

both as a formula and the equivalent value entered into a cell as a text
constant. A decimal order and a half magnitude difference between the docs
and what actually can be achieved is a bit more than the fudge factor
mentioned in some KB article I've seen. Or would you claim 15,751 is
approximately equal to 1,024?

End quote...........................................


Gord

 

[RagDyer]

So ... I guess we can say, well in excess of 15K of characters.

I think Harlan really takes pleasure in sticking his foot up butts, whether
MS's or anyone else's, for that matter.<bg>

Thanks again Gord!

 

[Gord Dibben]

Yeah, I know.

Both those Harlan posts were in response to mine stating the 1024 limit.

We all learned something there<g>


Gord

 

[evilyn]

it worked when i put it forced line breaks. the character count is
2094 which makes it even more odd that it would not all show up.

 

[RagDyer]

Thanks again for answering.