How to count the frequency of words in excel
 

Hello everybody,

I would like to know a simple way to count the frequency of words in excel.

Thank you in advance
--
DD

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