what is the formula to count words in excel?
Count words in a single cell Please enter this formula =IF(LEN(TRIM(A2))=0,0,LEN(TRIM(A2))-LEN(SUBSTITUTE(A2," ",""))+1) into the Formula Bar, and then press the Enter key. Note: In the formula, A2 is the cell you will count number of words inside.