Changing a formula on the worksheet

[Shashi Bhosale]

I have a worksheet with hundreds of formula, each formula has a option to
check for a site.
ex:
=SUMPRODUCT((DataSite="ABC")*
(DataAcc>=510115)*
(DataAcc<=510115)*
(DataAmount)
)

How do i change Site to 'XYZ' globally without goin to each cell and change
the formula to have site 'XYZ'.

Thanks in advance,

Shashi

 

[Shashi Bhosale]

Great.... Thanks.

Toggle the sheet to Formula View (CTRL + `), then do an Edit, Replace...
Then toggle back to regular view (CTRL + `)

Note: The ` is on the same key as the tilde (~).

MRO