word count in Excel

H

Help Needed 2

how to count words in excell?

formula provided by F1 Excel help doesn't work, the cell showing the text of
the formula

I made sure there are no circular references (formula cell and the range it
was to calculate are mutually exclusive).
 
A

Anirudh

HI,
for word count in a cell try this
=len(cell ref)
or count the no. of unblank cell try this
=count(rer)
 
Top