Hi Greg-

From Excel 2000 Help (I believe this applies to '97 as well);

Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

HTH |:)

"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