Counting characters excepting spaces using excel formula

counting characers without spaces

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 […]