30
Excel Formulas to Count specific word in a cell ~ Quick Tricks!!
For instance, you have a list of text strings in a range, and you need to count the specific words in a cell. Do you have any good methods for solving this task in Excel? In this post, we are going to discuss the formulas to count the specific word in a cell in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

=(LEN(text)-LEN(SUBSTITUTE(text,word,””)))/LEN(word)
Refer to the below example image.




30