I have a bunch of formulas that I need to copy and then change the cell column they're referencing.
However, if I select the formulas and FIND and REPLACE (let's say) D with E...it will change other characters including Sheet names and other functions such as AND, which of course is less than useful.
Is there a way I can get it to just change the cell reference?
I'm using Excel 2010.
Thanks for any help.
Bookmarks