"Formula is too long"

[gobonniego]

All I'm trying to do is find and replace ONE word in each cell in a column.
Did it before, but won't do it now. Even when I try to hit Find Next and
then Replace (instead of Replace All), I'm getting this answer. Any answers?

 

[Dave Peterson]

I think I saw a post by Jan Karel Pieterse that his newest FlexFind will do
this:

http://www.oaltd.co.uk/MVP/

If you want to mess around with your own macro:
http://groups.google.co.uk/[email protected]

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm