View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default 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?