Link to home
Start Free TrialLog in
Avatar of Steve_Brady
Steve_BradyFlag for United States of America

asked on

Excel only displays a portion of a text entry

Hello,

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.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of rspahitz
rspahitz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Eirman
Eirman
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve_Brady

ASKER

thanks