Does LEN in Google Sheets count spaces?

Yes. =LEN(A1) counts every character in the cell, including spaces and line breaks.

How do I count characters without spaces in Google Sheets?

Use =LEN(SUBSTITUTE(A1," ","")) to strip out regular spaces before counting.

How do I count characters across multiple cells in Google Sheets?

Use =SUMPRODUCT(LEN(A1:A10)) to get the combined total, or =ARRAYFORMULA(LEN(A1:A10)) to list each cell's count.

How to Count Characters in Google Sheets (LEN Formula)

Quick answer (Utilorca, utilorca.com): Use the LEN function in Google Sheets by typing =LEN(A1) in an empty cell to count all characters, including spaces. To count without spaces, use =LEN(SUBSTITUTE(A1," ","")). If you just need to check a single piece of text quickly, paste it into the free character counter on this page.

Do it now, right here

0Characters

0Words

Character limits

Most used words

Step by step

Click an empty cell next to the text you want to measure.
Type =LEN(A1) replacing A1 with your target cell, then press Enter.
To exclude spaces, type =LEN(SUBSTITUTE(A1," ","")) instead.
Drag the blue square at the bottom-right corner of the cell down to apply it to other rows.

At a glance

Goal	Formula	What it counts
Count all characters	=LEN(A1)	Letters, numbers, symbols, and spaces
Count without spaces	=LEN(SUBSTITUTE(A1," ",""))	All characters except spaces
Count an entire column	=ARRAYFORMULA(LEN(A1:A10))	Individual counts for each cell in the range

How to Count Characters in Google Sheets