How to count the frequency of words in excel

  • Thread starter Thread starter deedee
  • Start date Start date
D

deedee

Hello everybody,

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

Thank you in advance
 
Hello everybody,

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

Thank you in advance
Click to expand...

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
 
Back
Top