Microsoft Excel Hints and Tips

Question
How do I count the number of words within a cell ?

Solution
Type the following formula =LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1 - assuming that you want to count the number of words within cell A1.

Back to Questions Index

Return to Excel Exchange homepage.