You need to do the 2 replaces as well as the remove hyperlinks (you don't need to select the individual cells, you can do the whole column in one). Btw Havant isn't far away from me
If you could post the actual file the I would do it for you but as that isn't an option maybe you could copy/paste the offending column to a different workbook then I could convert it, repost it and then you could paste it back rather than creating a whole new file.