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!

Find

SUM($C

and replace with

SUM($D

use the look in formula option.

HTH,
Bernie
MS Excel MVP


"krkward" wrote in message
...
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!

Find
=sum($c

Replace with
=sum($D

If this post helps click Yes
---------------
Jacob Skaria


"krkward" wrote:

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!

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


"krkward" wrote in message
...
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!