Remove text between html tags

You could try using PowerQuery Text Between function and use '>' and '</' as the delimiters.

You can also do this in DAX using PATHITEM and SUBSTITUTE.

InnerHTML = 
PATHITEM( // Splits the string using delimiter "|", and takes the 2nd item that is a type of Text
    SUBSTITUTE( // Output <div class="Whatever"|Staff going to storage training|div>
        SUBSTITUTE([Html], ">", "|"), // Output <div class="Whatever"|Staff going to storage training</div>
        "</","|"
    ),
    2,
    TEXT
)