Microsoft Excel Hints and Tips
How do I count the number of words within a cell ?
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.