html tags

Hi PudduckD - can you please share more details with sample data . as per my understading, do you want to remove the HTML tags ?

if yes in power query editor we can do it, via different data transformations by creating new custom column  and using Text.Replace() m functions:

eg.,= Text.Replace(Text.Replace([YourColumnName], "<font face=""Arial"">", ""), "</font>", "")

or by using DAX Resolved solution:

Solved: How to remove html tags from some rows. - Microsoft Fabric Community

Hope it works

Hi thanks for your answer, i managed to figure it out and yes i did use a custom column but used the following formula = Html.table ([HTML Text],{{"plaintext"",":root}})