LEN

Office Components Spreadsheet Function

Show All

LEN

See Also

LEN returns the number of characters in a text string.

Syntax

LEN(text)

Text   is the text whose length you want to find. Spaces count as characters.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

Data
Phoenix, AZ
 
     One
Formula Description (Result)
=LEN(A2) Length of the first string (11)
=LEN(A3) Length of the second string (0)
=LEN(A4) Length of the third string, which includes 5 spaces (8)