Microsoft Excel: How to Count Number of Spaces in Cell String
B1: =LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))
Notice the space there. You can replace that with any other letter to see how many instances of that character are present. It’s simple and genius.