Exclude HTML code

[Marie Bayes]

Hi Experts

I have a query that pulls in data from a database, one of the fields
contains HTML code in amongst the relevnat data. My question is, is there a
way to exclude or translate the HTML code within the spreadsheet?

Thanks in advance