Dave Peterson wrote:
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???
Thanks a lot, Dave. Finally I have isolated the problem. As you pointed
out, the problem does not happen with just any Excel formula, but it
can happen in extreme cases like mine. (I was concatenating a lot of
cells, and those cells themselves consisted of a bunch of formulas.) I
finally did find a way around the problem by copying and pasting the
values to another part of the spreadsheet.
Anyway, thanks again for your help. You got me moving in the right
direction.
Greg
|