Possible to find/replace text with a formula?

[grexcelman]

I have multiple tabs with dozens of cells containing a year that had been hard coded as text. I'm trying to find replace that text with a formula that links to a cell on a separate tab used for updating the year for all of those cells in question.
I'd like to replace '2015 for a formula that reads =Year!$A1$

is it possible to find replace each text occurance of the year with this formula? In each attempt I've made, the formula gets inputed as a string of text instead of the working formula.

thanks.

 

[Scott Huish]

Select the cells with '2015 and do a TextToColumns and just click Finish on the first tab. This will get rid of the leading ' mark

Then do a find and replace of 2015
Have the option for Entire Cell Contents checked and replace with your formula.