Single Quotes in HTML links

Alright, so I just got handed back something I was working on. Basically, I have HTML links for product install guides in these cells. The formula a friend did to add the HTML around the links made them single quote and they turned out like this: <.a href=&#39.http://www.airraid.com/InstallationPDF/200-206-1.pdf&#39.>Click here for install instructions.<./a>

On the site it shows the link as http://www.sitename.com/catalog/'htt...id.com/install...

So now I need to clean up 300+ cells with this &#39 in them and replace those with double quotes. Is there any function that could be written to fix this? The cells have too much data in them for a simple find and replace. I tried FlexFind, but it ended up adding infinite .pdf" to what I wanted to fix. [example: .pdf".pdf".pdf".pdf" and so on.. never done that before. Weird!]

Any help and input would be greatly appreciated!

samplesheet.xls

Try, in an unused column:

Please Login or Register  to view this content.

and copy down