Excel

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

By using =Len() you’re going to return the character count including spaces by default. Example: =len(“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(“hey there”,” “,””)) This will return: 8 How does this work? By nesting the …

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

Scroll to Top