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