How to Count Words In A Cell
Sometimes we might come into a situation that we should know what is the the number of words in a particular cell .
Eg: Given below are the name of 4 engineering colleges in Kerala .Here we want to know how many words are the in the name of each college
The formula for finding out the number of words in a cell is
LEN(Ref Cell )-LEN(SUBSTITUTE(Ref Cell," ",""))+1
No comments:
Post a Comment