replave word in formula

D

Darius

hi
how to replace a word with another word in formula for a range of cells.
Like we have a1:c10, all have a formula, say "Rita" now we want all cells
keep same formula but name change to "Katrina"? I tried Edit>>>replace
does not work, any suggestion?
Thanks
Darius
 
Top