Excel will accommodate formulas that are 1024 characters long (measured in R1C1
reference style).

Maybe it's something else that's wrong.

Jacky Hope wrote:

I encounter the problem that Excel does't allow me to enter a formular in
which containts very long letter. It may be longer that 500 letters.

how can i do to enlarge the capacity of the cell to be able to accommodate
the long characters which may be longer that 500 letter.

--

Dave Peterson