large text in a cell?

B

Brent

Is there a limit to how much text you can have in a cell? Can you expand
that limit?

I have a column of data where each cell of that column has a lot of text in
it. I have not been able to get the cells in that column (with large text)
to display or print the text in those cells- no matter how large i expand
the column or the row...

any ideas
Thanks
brent
 
J

JE McGimpsey

The limit is 32767 characters. Prior to XL07, the display limit is 1024
characters. You can extend that by inserting a manual linefeed
(CHAR(10)) every 1024 characters.
 
B

Brent

To insert a manual linefeed, do I do an <alt> enter?
What about spliting the cell?
How about linking an object (notbook or word text item) to that cell?

Thanks
Brent
 
Top