How to count the frequency of words in excel
On Thu, 22 Jan 2009 17:09:01 -0800, deedee
wrote:
Hello everybody,
I would like to know a simple way to count the frequency of words in excel.
Thank you in advance
There is one word in "Excel" :-)
To count the number of words in a string in a single cell, you can count the
number of <space's and add one:
=len(a1) - len(substitute(a1," ","")) +1
If you want something else, please post back with more detail.
--ron
|