Friday, 19 June 2015
Excel formula to Count Specific Words in a Cell
Labels:
Excel
=(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.
Subscribe to:
Post Comments
(
Atom
)
statistics
Popular Posts
-
This Acrobat Error happens often with My Acrobat Pro. I was searching online for a solution none of the articles gave me a solution finally... -
This article intend to show how to resize an already existed PDF's page size. Let say you have a PDF page which is in A2 size probabl... -
When it comes to get your money into your pocket it is vital important how are you going to withdraw. These questions may rise in your mind...
-
This tutorials shows you how to count specific words in excel cell. As shown in the picture we are going to find the number occurr... -
There is no in built function in excel for removing whites spaces when it appears at the end of a text or middle of a text , but you may ... -
I'm an Excel user for may years and I'm good at working with excel conditional formatting. However When my clients asked me to do a...
No comments :
Post a Comment