The post demonstrated how we could count number of braces “<>” in Excel.

I have personally seen people HTML developers struggling to perform tasks in excel that involves “<>” symbol.

We will use two simple formula in excel called LEN and SUBSTITUTE to count the pair of <>.

As shown below we have HTML code in the cell A2 and we want to count number of <> symbol

**Step 1**

Enter the below formula in the cell B2

**=(LEN(A2)-LEN(SUBSTITUTE(SUBSTITUTE(A2,”<“,””),”>”,””)))/2**

So this formula works on counting the combination of “>” for each open “<” symbol.

Hope this helped.