Hi,

I have a document we use a lot listing clients' sites and details. Over time the links in the sites (HTML links to the corresponding URLs) have become broken due to edits in the document. We're looking at many hundreds of broken links, and I'd like to fix the mess.

I've been searching for a way to automatically fix all the links to lead to http://contentsofthecell

I did find some pro addins and installed one trial version, only to find it tells me I have no links - I think because it is looking for non-URL type Excel links.

Can anyone suggest a way to do this?I'm guessing it is an easy search/replace function, if you know how.

Thanks,
Kevin