Text wrap spec

[John]

People,
I thought I understood that the text wrap limit for any given cell was
1024 and indeed when I look at the specification for Excel, it states
that only 1024 text characters will display in a cell. However, I have
the following condition (Excel 2003 running under Windows XP Pro).

I have a column that is 35 wide. I entered repeating text in four
paragraphs. The total length of my string is 1093 characters (verified
using the Len function). The last word wrap occurs at character 1032,
definitely beyond the 1024 limit. The total number of characters that
shows in the cell is 1074 and that last character, an "e", is partially
cut off by the cell's right boundary.

Clearly the total number of text characters that will display in a cell
is greater then 1024. So what is Excel's specification trying to tell
me? Is it flat out wrong or am I misreading (misinterpreting) it?

Please enlighten me.

John
Project MVP

 

[Earl Kiosterud]

John,

If you put CR's (Alt-Enter) periodically in a cell, it extends the count of characters that
a cell will display. Since you have four paragraphs, it seems that's what you have.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[John]

John,

If you put CR's (Alt-Enter) periodically in a cell, it extends the count of
characters that
a cell will display. Since you have four paragraphs, it seems that's what
you have.

Earl,
OK, but how much does a line feed add to the max characters limit? It is
definitely more than one character per line feed because I already
considered that.

John

 

[Earl Kiosterud]

John,

I don't know how many more characters line feeds allow. No one else has jumped in. I think
it's not hard-and-fast.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

 

[Dave Peterson]

I put this in A1:

="yyy"&CHAR(10)&REPT(REPT("asdf ",40)&CHAR(10),30)&"xxx"
It resulted in a string with 6037 characters.

I could adjust the rowheight, columnwidth, font size, and zoom factor and seel
all the characters.

Maybe you could experiment to find out if it fits your needs with your settings.