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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

offset formula causing Circular reference 0
Remove Identical words 0
Is there a function to count how many times a cells value is used? 0
Excel - Wich Function should I use? 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Macro to Select text from a point given to a specific word 2
Merging from an Excel file with graphics 1
Formating bolded text exclusively. 0

Top