Find & replace

[Kathy]

I need to do a find and replace on a column of text. The
problem is that some of the cells contain a lot of
characters and excel gives me the error message "Formula
is too long". Is there any way around this?

 

[Dave R.]

This is weird. but you could try a substitute formula, then copy/paste the
result of the formula over the original text.

like if you have a cell containing "apples and football" and you wanted to
replace "football" with "oranges", you would do

substitute(a1,"football","oranges")