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
Enter the below formula in the cell B2
So this formula works on counting the combination of “>” for each open “<” symbol.
Hope this helped.