Find and replace a string in hundreds of anchors

[dagda13]

Hi,

I have an excel sheet that has hundreds of anchors. I've tried to find a string that is exists in all of the them and replace it with another string. When I try to do this with find / replace, it doesn't detect the string even though it's in the link. Is there a way to do this? I'd rather avoid VBA, is possible.

 

[Micron]

If you don't get an answer I may be able to help with a vba solution. Excel formulas are not my thing.