Errors
The LEN function is the primary way to count characters in Excel. Type =LEN(A1) in any cell to count the total number of characters in cell A1, including spaces and punctuation. For more advanced scenarios — like counting specific characters, excluding spaces, or counting across a range — you combine LEN with SUBSTITUTE, SUMPRODUCT, or other functions.
Character counting is commonly needed for SMS and tweet length limits, data validation rules, cleaning imported data, and quality checking text fields. This guide covers every character counting scenario you are likely to encounter.
Click any empty cell, type =LEN(A1) (replacing A1 with your cell), and press Enter. The result is the total character count including spaces.
Method 1: Count All Characters with LEN
LEN counts every character in a cell including letters, numbers, spaces, punctuation, and special characters.
Click an Empty Cell
Click the cell where you want the character count to appear.
Type the LEN Formula
Type =LEN(A1) replacing A1 with the cell reference you want to count.
Press Enter
The cell displays the total number of characters. For example, if A1 contains Hello World, the result is 11 (including the space).
Tip: LEN counts leading and trailing spaces that may not be visible. If you get an unexpected count, wrap the cell reference in TRIM first: =LEN(TRIM(A1)) to exclude extra spaces.
Method 2: Count Characters Without Spaces
To count only non-space characters, combine LEN with SUBSTITUTE to remove spaces before counting.
Use the LEN + SUBSTITUTE Formula
Type: =LEN(SUBSTITUTE(A1," ","")). This removes all spaces from the text, then counts the remaining characters.
Press Enter
The result is the character count excluding all space characters. For Hello World, the result is 10.
Method 3: Count a Specific Character in a Cell
To count how many times a specific character (like the letter a or a comma) appears in a cell, use LEN minus LEN after removing that character.
Use the LEN-SUBSTITUTE Formula
Type: =LEN(A1)-LEN(SUBSTITUTE(A1,"a","")). Replace a with the character you want to count.
How It Works
SUBSTITUTE removes all instances of the target character. LEN counts the original length and the shortened length. The difference equals the number of times that character appeared.
Make It Case-Insensitive
By default this is case-sensitive. For case-insensitive counting, use: =LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A","")).
Method 4: Count Characters Across a Range of Cells
To get the total character count across multiple cells (A1 through A10), use SUMPRODUCT with LEN.
Use SUMPRODUCT + LEN
Type: =SUMPRODUCT(LEN(A1:A10)). This applies LEN to each cell in the range and sums the results.
Press Enter
The result is the total number of characters across all cells in the range. Empty cells contribute 0 to the total.
Method 5: Count Characters in Google Sheets
Google Sheets uses the same LEN function with identical syntax.
Use LEN in Google Sheets
Type =LEN(A1) in any cell. All the formulas from Methods 1-4 work identically in Google Sheets.
Use the Built-in Character Count
Select a cell in Google Sheets. The character count appears in the status bar at the bottom-right of the screen next to Sum and Average.
Warning: LEN counts characters, not bytes. Unicode characters (emojis, Chinese characters, etc.) count as 1 character each with LEN, even though they may occupy multiple bytes in storage. Use LENB if you need the byte count instead.
Why Count Characters in Excel?
Character counting serves multiple practical purposes in data management. SMS messages have a 160-character limit. Meta descriptions should be 150-160 characters for SEO. Tweet lengths are limited to 280 characters. Database fields often have maximum character limits. Data validation rules may require minimum or maximum text lengths. Product descriptions on e-commerce platforms have character limits. Ad copy for Google Ads has strict character restrictions per headline and description. The LEN function enables you to check compliance with all these limits directly within your spreadsheet.
Frequently Asked Questions
Use the LEN function: =LEN(A1). This returns the total number of characters including spaces, numbers, punctuation, and special characters.
Yes, LEN counts all characters including spaces. To exclude spaces, use: =LEN(SUBSTITUTE(A1," ",""))
Use: =LEN(A1)-LEN(SUBSTITUTE(A1,"x","")) replacing x with the letter you want to count. This is case-sensitive by default.
Yes, use =SUMPRODUCT(LEN(A1:A10)) to get the total character count across a range of cells.
LEN counts characters (each character = 1 regardless of encoding). LENB counts bytes (some characters like Chinese/Japanese take 2 bytes). In Western text, both return the same result.
Excel has no built-in word count function, but you can approximate it by counting spaces: =LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1
Yes, LEN works with both text and numbers. =LEN(12345) returns 5. For formatted numbers (like dates or currencies), LEN counts the displayed characters.
Use Data Validation: select the cells, go to Data > Validation > Allow Custom, and enter: =LEN(A1)<=160 (replacing 160 with your limit).
Yes, LEN counts line breaks (entered with Alt+Enter) as characters. Each line break counts as 1 character.
There is no single formula for this. You would need a helper column or a VBA macro to extract and count unique characters. For simple cases, count each character individually and sum the results.