If you insert alt-enters in your text (or &char(10)& in your formulas) every
80-100 characters or so, then you can see lots more than the document 1k number
of characters.



Greg Boettcher wrote:

I can't seem to use formulas in Excel 97 to produce blocks of text that
are bigger than about 1000 characters. I have gotten around the length
restrictions of the formulas themselves by doing a lot of concatenating
of strings, but I have found no way to increase the volume of text that
a formula generates. Instead of 1000 characters, I need about 3500
characters. Is there any way to achieve this?

Thank you to whoever can help me with this.

Greg

--

Dave Peterson