Replace a portion of a formula

  • Thread starter Thread starter krkward
  • Start date Start date
K

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!
 
Find

SUM($C

and replace with

SUM($D

use the look in formula option.

HTH,
Bernie
MS Excel MVP
 
Back
Top