My husband has 400 different formulas to change. Is it possible to use the
find and replace feature with that?
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.
quot;Tennfourquot; wrote:
gt; My husband has 400 different formulas to change. Is it possible to use the
gt; find and replace feature with that?
On Mon, 13 Feb 2006 12:37:38 -0800, quot;Tennfourquot;
gt; wrote:
gt;My husband has 400 different formulas to change. Is it possible to use the
gt;find and replace feature with that?
Yes
--ron
- Jul 25 Fri 2008 20:45
Can the quot;Find and Replacequot; feature be used in Formulas somehow?
close
全站熱搜
留言列表
發表留言
留言列表

