find and replace units of a formula
 

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

find and replace units of a formula
 

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

"Roger" wrote:

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

find and replace units of a formula
 

Make sure when you set up to do the Find and Replace that the "Look In"
setting is Formulas and not Values.

"Roger" wrote:

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

find and replace units of a formula
 

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...

"JLatham" wrote:

Make sure when you set up to do the Find and Replace that the "Look In"
setting is Formulas and not Values.

"Roger" wrote:

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