Count words, but not HTML tags

[chilly_bang]

Hi
i want to count all words in a cell, but not those, which are placed between < and >. Or, count all words, which are placed between > and <.
How can i accomplish this? With regex it is a nobrainer, but in Excel - no clue

 

[Peter_SSs]

with regex search for <[^>]*> and replace with nothing, i get slightly different word amounts, as with your UDF. Could you explain me such difference? The numbers i get with your UDF are always a little bit higher, but i can't understand, what is counted differently.

I believe that you method is flawed. Example

"apple<some html tag>orange"

That text contains two words not in the html tag but if you replace the tag section with nothing, the result is "appleorange" which would be correctly counted as one word by any word-counter.
Try replacing the tag with a space (which is what our routines do) and see how it compares.