Article updated on April 18, 2018

The LEN function returns the number of characters in a cell value.

Formula in cell D3:

=LEN(B3)

Cell B7 contains a single space character, the LEN function accurately returns 1.

Excel Function Syntax

LEN(text)

Arguments

text Required. The text string or cell reference you want to count the number of characters in.

Comments

The LEN function does not count the number of characters in a formula, however, it counts the number of characters a formula displays.