find and replace units of a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hopefully this is simple. I often want to preform a find and replace
sections of a formula, say I want to change the reference column form A to D
or something..
currently I have hundreds of formulas that are sum(G11:AD11) and I'm trying
to find and replace the :AD with :M, but when I perform this function, I get
a message that it is not finding anything. I swear I did this exact same
thing on a worksheet yesterday and it work like a charm. what am I doing
wrong?

Thanks
 
Perhaps you forgot doing

Tools|Options|view and then checking view formula before doing your
Find/Replace.

The shortcut for switching between view formulas/Results is

Ctrl+`

The ` is to the right of the 1 key.

Mike
 
Make sure when you set up to do the Find and Replace that the "Look In"
setting is Formulas and not Values.
 
got it thanks, it wasn't that, but when I looked there i found that the check
box for look in entire cell what set, errrr...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I find & replace pieces of a formula? 4
find/replace 2
Find/Replace 5
Find and Replace 6
How to replace a formula string with * in the leading position? 3
Find and Replace ROUNDUP(stuff, 0) 3
Find & Replace: find part cell, replace whole cell 2
Using wild card characters in Find & Replace 6

Back
Top