Find and Replace with a formula

Looking for some help to convert some formulas through VBA. I have a workbook that is heavy with INDIRECT formulas, and I would like to convert those indirect formulas to static look-ups.

Example code:

Please Login or Register  to view this content.

I would like this to read:

Please Login or Register  to view this content.

But running Find/Replace within Excel I keep getting a popup that the formula isn't set up properly and the find/replace does not work through the Excel UI or through VBA.

Thoughts?

Thank you

=IF('10 - PartsSummary'!N21">0,1,0)

You don't want the " before the > in the formula.