How to deal with difficulties using CtrlF

I have copied sheets from an old version of an app to a new one. This works perfectly on my computer where both versions were saved but fails when copied to another part of the network where it could be accessed by another machine.
I realised that the new version formulas referenced the path of the old version when referring to a cell. When run on another part of the network this path/address was not available.
I want to use CtrF to find these cells and replace the offending path with a blank, but there is a problem.
An example of how the formulas in the new version look is :-
=INDEX(E:E,MATCH(F14,'C:\Users\js\Desktop\[Management accountsV5.0.xlsm]AdjustedCodes'!C:C,0))

I want to delete that part underlined but when I try to do this by REPLACE by a blank I get a formula error because of the pesky inverted comma between AdjustedCodes and !. There are over 200 formulas with this problem and I don't want t fix them by hand is there anything I can do?
John

I'm completely lost to be honest.

If your value is

Please Login or Register  to view this content.

and your replacement value is left completely blank, the returning formula should be

Please Login or Register  to view this content.

Instead of using Replace, why not just rewrite the formula. You know what you want it to be, so use a for loop to write it into the cells.

Please Login or Register  to view this content.

Of course, you need to tweak it to put the formula in the proper cell and such. This is just a crude example of the idea.

Just ran a test locally using the replace function and it worked as it should. I can only assume user error.