How to count the frequency of words in excel

[deedee]

Hello everybody,

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

Thank you in advance

 

[Ron Rosenfeld]

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