Replace a portion of a formula

[krkward]

Does anyone know of a way that I can replace a portion of a formula
throughout a worksheet without changing the other part?

I have been able to find the cells that need to be changed by searching for
=SUM($C?*$E$1)

I need to change the C to a D is all cells. Is this possible?

I'd appreciate any help! Thanks!

 

[Bernie Deitrick]

Find

SUM($C

and replace with

SUM($D

use the look in formula option.

HTH,
Bernie
MS Excel MVP

 

[Jacob Skaria]

Find
=sum($c

Replace with
=sum($D

If this post helps click Yes

 

[David Biddulph]

You might also want to think about whether you needed the SUM function. Was
there something that you wanted to add to $C2*$E$1, for example, or was your
formula intended to have been just =$C2*$E$1 ?

If you don't know what the SUM function does, look it up in Excel help.