Whenever I have to apply more complex text operations I tend to use regular expressions.
If you want to remove HTML tags from a String, nothing is faster and easier than using regular expressions to do so.
This code references the following API, which is a VBScript API.
"Microsoft VBScript Regular Expression Reference 5.5"
In order to reference this API in Excel VBA go to Options -> References (In German "Extras" -> "Verweise") and tick the API above.