View Single Post
  #1   Report Post  
Darius
 
Posts: n/a
Default replave word in formula

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 Editreplace
does not work, any suggestion?
Thanks
Darius