Hi Neil

without seeing your formula it's hard to tell ... but help says that
formula's are limited to 1024 characters, so if it's longer than that maybe
a different approach is needed.

If you'ld like to paste your "desired" formula with a bit of a description
about what you're trying to achieve maybe we can suggest other options.

Cheers
JulieD

"Neil_J" wrote in message
...
I have several formulae that I need to make the same change too. I tried
Find-replace but got an error message saying the formula is too long.

So, I thought I would make the change manually but every time i press F2
or
click in the formula bar, Excel crashes.

I then pressed Ctrl+` so that I could paste the formula into Word, make
the
change then paste it back. However, when I copy and paste it into Word,
it
only pastes part of the formula, not all of it.

Anyone know how to get round this?

Thanks in advance