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


"Help Needed 2" wrote:

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).