Chilly Bang Chilly Bang - 3 months ago 13
HTML Question

CountIf of HTML tags in Excel

How should i format COUNTIF to find HTML tags?

I tried

=countif(a2;"<b>")
- fail. Tried to decode HTML entities and then
=countif(a2;"&lt;b&gt;")
- same fail.

Answer

If there is some text arround <b> in A2 cell contents, please try :

=countif(a2;"*<b>*")

"<b>" means exact search

"*<b>*" means contains

Comments