Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the frequency of words in excel | Excel Discussion (Misc queries) | |||
how to get grand total in words in excel sheet | Excel Worksheet Functions | |||
Compare the words in columns of the excel sheet | Excel Discussion (Misc queries) | |||
How do I Convert Figures into Words in Excel sheet | Excel Worksheet Functions | |||
date values change when I copy an excel sheet to a new book | Excel Discussion (Misc queries) |