Clean up html formatting stored in table column

We are using notes to store data in an application table (Oracle Cloud PPM, Project setup); users are copying and pasting data from an html page and inadvertently pasting in html formatting into the field.

Is there a way to programatically clean this data.

for example

text 

I want to only output text onto an Excel OTBI report. right now it outputs text&nbsp.

Thank you!

Esmeralda