Excel formula to Count Specific Words in a Cell

This tutorials shows you how to count specific words in excel cell. As shown in the picture we are going to find the number occurrences of word "Prince" in Cell "A2". On Cell "B2" is the word that we are searching for. The formula in cell c2 as below.

=(LEN(A2)-LEN(SUBSTITUTE(A2,B2,"")))/LEN(B2)  

A2= the text from which we look for specific word
B2= the text which we are searching for

Description about this function. 

Subtract the length B2 cell from length of A2 cell and dive the all length by length of of B2 cell which gives the numbers of occurrences.

The functions used here are Len() and Substitute.