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