Microsoft Excel Hints and Tips

Question
Is there a way to count the number of words within a range ?

Solution
Type the following formula =SUM(LEN(TRIM(A1:C3))-LEN(SUBSTITUTE(A1:C3," ",""))+1)-SUM(IF(ISBLANK(A1:C3)=TRUE,1,0)) - assuming that you want to count the number of words within the range of cells A1:C3.

After you have entered this formula you must select the cell that has the formula and then press F2 and then Ctrl + Shift + Enter to make this an Array Formula.

Back to Questions Index

Return to Excel Exchange homepage.