Find & replace

  • Thread starter Thread starter Kathy
  • Start date Start date
K

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?
 
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")
 
Back
Top