Excel only displays a portion of a text entry
Posted on 2011-05-03
In Excel (2007), I have pasted a large text document (a book with several hundred pages) in column B. It was pasted so that each cell includes one paragraph.
Because I need to have certain paragraphs formatted in different ways, I have hidden col B and have chosen col E to actually display the text. That is easily accomplished by formatting col E to Wrap Text and by entering =B# formulas in col E all the way down.
(FYI, a simple example of the formatting I'm after is being able to indent the first line of a large paragraph in row 8. The actual paragraph, which is hidden, is located in B8. It is displayed [with the first line indented] in E8 by using the formula: =" "&B8.)
The problem I'm having is that for some reason, cells in col E will display no more than 1018 characters from col B. In other words, for any paragraph in col B with more than 1018 characters, col E will display only the first 1018 characters and no more.
For example, =LEN(B87) gives a value of 1809 but E87 displays only the first 1018 characters. Interestingly however, =LEN(E87) also gives a value of 1809.
Any idea what would be causing that?
BTW, I pasted the content into a new spreadsheet and did not have the same problem so it's something unique to this one. I'm loathe to take the time to move everything to a new file though and I would really like to know the cause if possible.