Removing (') from names in cells.

Hi Guys,

I have a list of names around about 3500 or there abouts, some of these names have (') in them example "Al’s Memory" I would like to in one go remove all the (') from any name in the column. Usually I would just go to "Replace" and do it through that but every time I try I get the following message "We couldn't find anything to replace. Click Options for more ways to search" "FYI: It's possible the data you're trying to replace is in a protected sheet. Excel can't relace data in protected sheets"

No I know its not protected as it is me who made the sheet and I have also taken it from the original spreadsheet and pasted it as text into another to try it on here so it really has me stumped. So any help would be muchly appreciated. I have also attached an workbook with some of the data in it.

Thanks for the help guys problem solved, due to my silliness!

Much appreciated!