Remove specific text from only certain cells

[amoorman]

I am exporting lots of data from a website and for some reason to do with html i am getting   in a few cells in my description column (column C), i think that means "& " in html. this occurs in some cells but not others when i paste it into Excel. I would like to remove these characters.

I know I can do it with crtl H and the replace field blank but I would like a formula so in the future the user will simply have to paste information and then get converted information out (as they will struggle to use excel).

I think i need to use a combination of IF, FIND, REPLACE, LEN but i am struggling.

In a follow up problem some cells contain &amp which i believe is &, i would also like to convert this &amp back to &.

Many Thanks for any help

Ashley