Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools


Counting characters excepting spaces using excel formula


The easy way to count the characters in a text, without counting the spaces too, is to use the LEN excel formula on a string text that has the spaces removed.

Removing spaces before counting characters

Removing spaces inside a text is done by using the SUBSTITUTE formula with the following expression:

=SUBSTITUTE(“text where you need to replace spaces”,” “,””)

In this way spaces (” “) will be replaced with nothing (“”), resulting a string that has only the remaining characters.

Using LEN you can now find the number you are looking for:

=LEN(SUBSTITUTE(“text where you need to replace spaces”,” “,””))

counting characers without spaces

Good luck making Excel formula your friend!

  • Facebook
  • Twitter
  • Google+
  • Linkedin
  • Pinterest

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

This div height required for enabling the sticky sidebar