How do I get the length of every cell in a column in Google Sheets?

Use =ARRAYFORMULA(LEN(A2:A)) in the first cell of an empty column. Wrap it in an IF test on A2:A if you want blank rows to stay blank.

Google Sheets function

LEN in Google Sheets

In Google Sheets, LEN over a range returns a single number unless it is wrapped in ARRAYFORMULA, which gives one length per row.

LEN(text)

Combine it with an open-ended range such as A2:A to keep counting as the data grows.

For a fuller explanation of the arguments and common errors, see the LEN Excel guide.

	A
1	Text
2	Camp

Formula: C2: =LEN(A2)

Result: 4

The word contains four characters.

	A
1	Text
2	A B

Formula: C2: =LEN(A2)

Result: 3

The space between the letters is a character.

	A
1	Value
2	12345

Formula: C2: =LEN(A2)

Result: 5

The numeric value is converted to its text representation for counting.

A tiny spreadsheet with example data. Edit the formula or any number and see the result.

Formula in D2: =LEN(A2)

Result in D2: 13

How do I get the length of every cell in a column in Google Sheets?: Use =ARRAYFORMULA(LEN(A2:A)) in the first cell of an empty column. Wrap it in an IF test on A2:A if you want blank rows to stay blank.

Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.