Tips & Tricks 37 – How Many Characters a String is Containing not considering Blanks?

Say, you have a string like Vijay A. Verma and I need to know how many characters it has. In this case, it has 12 including decimal and leaving blanks aside.

Use below formula for the same –

=LEN(SUBSTITUTE(A1," ",""))