How to clean messy text in the column?

[BarbaraYanChen]

Hi there,

I have a messy text that has </...span/..div>... in it.  I need remove those charaters.  Below is the text that I need to clean, I also add the result that I want to archive.  It's appreciated if you could help out on the soultion.  thanks.

Text: <div class="ExternalClass2050E3CE38ED43F3B7CE1CA014A76EF2"><div style="font-family&#58;Calibri, Arial, Helvetica, sans-serif;font-size&#58;11pt;color&#58;rgb(0, 0, 0);"><span>Barbara likes reading, cooking, and travelling.</span><br></div></div>

Result: Barbara likes reading, cooking, and travelling.

[lbendlin · Accepted solution]

No need to clean anything. Parse the HTML.

let
    Source = Html.Table("<div class= ""ExternalClass2050E3CE38ED43F3B7CE1CA014A76EF2 ""><div style= ""font-family&#58;Calibri, Arial, Helvetica, sans-serif;font-size&#58;11pt;color&#58;rgb(0, 0, 0); ""><span>Barbara likes reading, cooking, and travelling.</span><br></div></div>",{{"Text","span"}})
in
    Source

[BarbaraYanChen]

It worked, thank you!