It was possible for me.

I put this in a cell:

=rept("a",32767)

I copied (with a simple ctrl-c) that cell and pasted into my favorite text
editor (UltraEdit32) and got 32767 characters.

Maybe it's the other program that you're pasting into???




Greg Boettcher wrote:

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.

Dave Peterson wrote:
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.

It isn't a question at all of how much I can see. I'm trying to copy
the contents of the cell and paste it to a text file. It's not working.
I'm only getting about 1000 characters.

I gather that what I want to do is not possible, but if somebody knows
otherwise, please let me know.

Thanks for the reply. :)

Greg

--

Dave Peterson