how much is too much data for a cell?
 

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.

how much is too much data for a cell?
 

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

--


Regards,


Peo Sjoblom


"evilyn" wrote in message
...
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.

how much is too much data for a cell?
 

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


"evilyn" wrote in message
...
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.

how much is too much data for a cell?
 

Thanks. I'll try that.

On Nov 30, 5:07 pm, "RagDyer" wrote:
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 !
---------------------------------------------------------------------------

"evilyn" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

how much is too much data for a cell?
 

Appreciate the feed-back.

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"evilyn" wrote in message
...
Thanks. I'll try that.

On Nov 30, 5:07 pm, "RagDyer" wrote:
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 !
---------------------------------------------------------------------------

"evilyn" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

how much is too much data for a cell?
 

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

On Mon, 3 Dec 2007 15:08:15 -0800, "RagDyer" wrote:

Appreciate the feed-back.

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

how much is too much data for a cell?
 

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

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Mon, 3 Dec 2007 15:08:15 -0800, "RagDyer"
wrote:

Appreciate the feed-back.

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

how much is too much data for a cell?
 

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

On Mon, 3 Dec 2007 15:55:15 -0800, "RagDyer" wrote:

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

how much is too much data for a cell?
 

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Mon, 3 Dec 2007 15:55:15 -0800, "RagDyer"
wrote:

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

how much is too much data for a cell?
 

Yeah, I know.

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

We all learned something there<g


Gord

On Mon, 3 Dec 2007 17:07:50 -0800, "RagDyer" wrote:

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!

how much is too much data for a cell?
 

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.

On Dec 3, 6:08 pm, "RagDyer" wrote:
Appreciate the feed-back.

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"evilyn" wrote in message

...



Thanks. I'll try that.

On Nov 30, 5:07 pm, "RagDyer" wrote:
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 !
---------------------------------------------------------------------------

"evilyn" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

how much is too much data for a cell?
 

Thanks again for answering.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"evilyn" wrote in message
...
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.

On Dec 3, 6:08 pm, "RagDyer" wrote:
Appreciate the feed-back.

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"evilyn"
wrote in message

...



Thanks. I'll try that.

On Nov 30, 5:07 pm, "RagDyer" wrote:
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 !
---------------------------------------------------------------------------

"evilyn" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -