How to count the number of occurrences of a character in Excel?
To count the number of occurrence of any particular word in the selected range of values, use the predefined function =Countif. Proceed with the below steps to count the text occurrence.
Step 1: In a cell, type as =countif( Then using mouse, click and drag the range of values from which you wish to get the count of a particular word.
Step 2: Once after selecting the range of values, enter comma symbol (,) and provide the word inside the double quotes. Then close the parenthesis.
Step 3: Hit enter to get the result. In the below example, the word bforball has occurred two times in the selected range of cells.