Let’s see how to count the occurrence of a character in text in a cell in excel.
We will write a formula to see the number of occurrences of a particular character.
In the below example we will see how to count the occurrence of “m” in the string “summon”.
Enter the formula =LEN(K7)-LEN(SUBSTITUTE(K7,”m”,””)) in the cell.
As you see the occurrence is 2.
Hope this helped.
Let’s see how to highlight cells in a column where the value changes in excel. Suppose we have sorted data […]
In this post we will see how we could generate random dates between two given dates in excel. Creating dates […]
how to restrict number of decimals in entire excel workbook, excel limit number of decimals in spreadsheet, how to restrict number of decimal places in the excel sheet
