Using the Excel LEN Function


The Excel LEN function returns the number of characters in a text string. The LENB function can be used to find the number of bytes used to represent the characters in a given text string. In both LEN and LENB spaces count as characters.

LENB counts two bytes per character when a double-byte character set (DBCS) language is used. DBCS languages include Japanese, Chinese (Simplified and Traditional), and Korean. If a DBCS language is not used then LENB performs the same as LEN and counts one byte per character.


=LEN (text)

=LENB (text)

Syntax Breakdown

Required. Text whose length you want to find.

Usage Notes

LEN and LENB return the number of characters (spaces and numbers included) in a text string. Number formatting (i.e. currency or accounting) is not included. For example, the length of 5 formatted as $5.00 will still return 1.