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?
|