ExcelBanter - replave word in formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - replave word in formula (https://www.excelbanter.com/excel-worksheet-functions/46791-replave-word-formula.html)

Darius

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

Darius

Actually it worked now, sorry.

"Darius" wrote:

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

All times are GMT +1. The time now is 12:05 AM.