View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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