 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Text wrap spec
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 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.  SignatureEarl 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... ----------------------------------------------------------------------- > People, > I thought I understood that the text wrap limit for any given cell was [quoted text clipped - 17 lines] > John > Project MVP > 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 > ----------------------------------------------------------------------- > > People, [quoted text clipped - 18 lines] > > John > > Project MVP 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. SignatureEarl 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, [quoted text clipped - 32 lines] >> > John >> > Project MVP 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. > > John, > > [quoted text clipped - 34 lines] > > > John > > > Project MVP SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.