Loading
Report thread as spam

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.

This question was started by evilyn 6 years ago

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

--

Regards,

Peo Sjoblom

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.

This response was posted by Peo Sjoblom 6 years ago

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 ( ) at appropriate places throughout the text. -- HTH,

RD


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


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.

This response was posted by RagDyer 6 years ago

Thanks. I'll try that.

I've been able to get over 5,000 to show by placing forced line breaks ( ) at appropriate places throughout the text. -- HTH,

RD


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


news:e2bf047d-217a-4650-9b87-143c61672503@e67g2000hsc.googlegroups.com...

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 -
This response was posted by evilyn 6 years ago

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 !


Thanks. I'll try that.

but I've been able to get over 5,000 to show by placing forced line breaks ( ) at appropriate places throughout the text. -- HTH,

RD


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


news:e2bf047d-217a-4650-9b87-143c61672503@e67g2000hsc.googlegroups.com...

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 -
This response was posted by RagDyer 6 years ago

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

Appreciate the feed-back.

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

This response was posted by Gord Dibben 6 years ago

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.

-- Regards,

RD


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


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" ragdyer@cutoutmsn.com

Appreciate the feed-back.

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

This response was posted by RagDyer 6 years ago

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

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.

This response was posted by Gord Dibben 6 years ago

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.

Thanks again Gord! -- Regards,

RD


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


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" ragdyer@cutoutmsn.com

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.

This response was posted by RagDyer 6 years ago

Yeah, I know.

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

We all learned something there

Gord

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.

Thanks again Gord!

This response was posted by Gord Dibben 6 years ago

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.

>

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 !

news:02aa16b0-9bc8-4ab0-806a-4b33c2dd9f99@e4g2000hsg.googlegroups.com...

Thanks. I'll try that.

but I've been able to get over 5,000 to show by placing forced line breaks ( ) at appropriate places throughout the text. -- HTH,

RD


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


news:e2bf047d-217a-4650-9b87-143c61672503@e67g2000hsc.googlegroups.com...

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 -
This response was posted by evilyn 6 years ago

Thanks again for answering. -- Regards,

RD


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


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.

>

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"

news:02aa16b0-9bc8-4ab0-806a-4b33c2dd9f99@e4g2000hsg.googlegroups.com...

Thanks. I'll try that.

display, but I've been able to get over 5,000 to show by placing forced line breaks ( ) at appropriate places throughout the text. -- HTH,

RD


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


news:e2bf047d-217a-4650-9b87-143c61672503@e67g2000hsc.googlegroups.com...

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 -
This response was posted by RagDyer 6 years ago

Other excel threads