Can the "Find and Replace" feature be used in Formulas somehow?

T

Tennfour

My husband has 400 different formulas to change. Is it possible to use the
find and replace feature with that?
 
P

pdberger

I've done that often and it's pretty easy -- especially if you want to make
the same change in each one. You're right -- just use the Find-and-Replace
(ctrl-H) feature.
1) Select the cells you want to change.
2) Press Ctrl-H.
3) Type in the text you want to change from.
4) Type in the text you want to change to.

At this point, I'd replace a couple of them one-at-a-time just to make sure
you're getting what you want. Then replace all.
 
Top