How do I count words on Excel book or sheet?
 

I'm using Excel 07 to organize the research and writing of a book. I need a
way to measure my progress by word count. Is there a more efficient way than
to cut/paste in Word just to get the count?

How do I count words on Excel book or sheet?
 

Yes. The more efficient way is to use Word instead of Excel.

If you insist on using Excel, the common way is to count spaces. Something
like:
=len(a1)-len(substitute(a1," ",""))

Regards,
Fred.

"Lisa J" <Lisa wrote in message
...
I'm using Excel 07 to organize the research and writing of a book. I need
a
way to measure my progress by word count. Is there a more efficient way
than
to cut/paste in Word just to get the count?

How do I count words on Excel book or sheet?
 

Here's a simple piece of code that counts all the words on a
worksheet. It assumes that each word is separated by a single space.

Sub WordCount()
Dim R As Range
Dim Total As Long
Dim V As Variant

For Each R In ActiveSheet.UsedRange
If R.Text < vbNullString Then
V = Split(R.Text, Chr(32))
Total = Total + UBound(V) - LBound(V) + 1
End If
Next R
MsgBox CStr(Total) & " words on all cells on sheets."
End Sub


Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Sun, 1 Feb 2009 08:26:00 -0800, Lisa J <Lisa
wrote:

I'm using Excel 07 to organize the research and writing of a book. I need a
way to measure my progress by word count. Is there a more efficient way than
to cut/paste in Word just to get the count?

How do I count words on Excel book or sheet?
 

assumed your range A1:C10.

Array function use ctrl + shift + enter

=SUM(IF(LEN(TRIM(A1:C10))=0,0,LEN(TRIM(A1:C10))-LEN(SUBSTITUTE
(A1:C10," ",""))+1))

source : microsoft website

On Feb 1, 9:26*pm, Lisa J <Lisa wrote:
I'm using Excel 07 to organize the research and writing of a book. *I need a
way to measure my progress by word count. *Is there a more efficient way than
to cut/paste in Word just to get the count?

You can also use a free tool to count the words in Excel files:

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

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