Microsoft Excel: How to Count Number of Spaces in Cell String

excel

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.

Comments

comments

Recent Posts