find and replace in excel

[Guest]

I want to find a way to replace automatically a single letter in a formula
without replacing the similar other letters in the same formula.
E.G. Sheet1!E45

change E45 to F45 without changing the other e's in the word sheet

Thank you

 

[Paul B]

Nicos, one way replace E45 with F45

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Fedor Shihantsov]

Hi!

With this Add-in you can make any possible search in formulas, see visually
all results, and then replace only the letter or other symbol you need in
the formulas you choose.

http://www.ablebits.com/microsoft-excel-addins-and-tools/advanced-excel-find-and-replace-addin.html