Dear friend,
Some times it is necessary to count any specific item from any cell. Then you can do it very easily by using below formula.
In above example, you can see four cities in cell A1 with three commas. I’m trying to count all commas in cell B1 by using formula. You can also look formula in formula bar.
Note: You can count any thing like comma.
Some times it is necessary to count any specific item from any cell. Then you can do it very easily by using below formula.
In above example, you can see four cities in cell A1 with three commas. I’m trying to count all commas in cell B1 by using formula. You can also look formula in formula bar.
Note: You can count any thing like comma.
