Excel formula to find the number of words in a cell | Find count of words in a text string in Excel

In this short video,, we will watch how to create an Excel formula to find the Count word in excel. Find count of words in a text string in Excel with an easy formula.
We used len formula in excel first and used TRIM to remove any unwanted space. we also used the substitute function to remove space.