Replace HTML codes (e.g. ")

I have a column of strings that contain a variety of HTML codes like:

"
'
&

And so on. I want to convert those codes to their string equivalent. Is there a function that does that?

I’ve thought about using String Replace (dictionary) but I’m hoping that’s the hard way.

Cheers, Richard