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

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

Good morning Anirudh

Chip Pearson has a useful routine to take care of this he

http://www.cpearson.com/excel/WordCount.htm

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=472898

Here is a free tool to count words in Excel:

http://www.montereylanguages.com/exc...free-tool.html

It counts the number of words in Excel files, also allows to exclude numbers (like years or dollar amounts) from the word count.