*How to Count Characters in a Cell with or Without Spaces in Excel*

Whenever or wherever we input text there is a possible character limit. Sometimes these limits come including or excluding spaces. In Microsoft word, counting words, characters (with and without spaces) are so simple. Just click on the status bar word count and you’ll get everything. But in Microsoft excel Counting Number of Characters in a cell alone requires function. If you want to get the character Count in Excel without spaces that require either VBA (Visual Basic Application) or more elaborate formula.

In this *Intermediate Excel Tutorial* I’ll explain *how to count characters in a cell excluding spaces in excel without vba.* We are going to count total characters inside a cell. We’ll also count characters in a cell excluding spaces in excel formula.

Without further ado let’s start counting. In this excel video tutorial I’ll show you how to write the formula that will help us counting character but before diving into the formula you need to understand two excel functions that will be used in this tutorial.

*Len Function:* https://youtu.be/M8O90E4piec
*Substitute Function:* https://youtu.be/5rOmoPuUKJY
Now that you know the foundation lets count the cell characters.

Suppose you have data in Column A and you need the character count in Column B.
Now write the formula in cell B2 =Len(A2)
This will give you a total character count in cell A2. The spaces will be included. Now if you want to count letters in the excel column just drag the formula down and it will give you the results for the entire column.

Now let’s count characters in a cell excluding spaces in excel without vba
Here the formula will be LEN(SUBSTITUTE(A2,/” /

Please take the opportunity to connect and share this video with your friends and family if you find it useful.