Excel Word Count: Tips and Methods. Excel doesn’t have a built-in option to count words like in MS Word, but you can create a formula to do it. Here’s how: Word Count in a Single Cell: =LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))+1 This formula counts the number of spaces in a cell and adds 1 to get the total … Continue reading Excel Word Count: Tips and Methods