Count characters in a cell without spaces – Excel & Google docs

By using =Len() you’re going to return the character count including spaces:


 = Len(a1) 

 where a1 = “hey there”

This formula will return “9”, this is because there’s a space between “hey” and “there”.

Here’s the formula to get character count without spaces:

=LEN(SUBSTITUTE(a1," ",""))

This will return: 8

There you go. This will work in both Excel and Google docs spreadsheets 🙂