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

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

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

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.

"Tennfour" wrote:

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

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

On Mon, 13 Feb 2006 12:37:38 -0800, "Tennfour"
wrote:

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

Yes

--ron