Home/Formulas/Text/LEN
Texteasy

LEN()

Returns the number of characters in a string.

Syntax
fx
=LEN(text)
Arguments
ArgumentDescription
textThe string whose length will be returned.
Try it
F2
→
6
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Counts characters, not bytes. Emoji that use surrogate pairs may register as 2: test if you depend on exact counts.
  • Trailing spaces count toward LEN. Wrap with TRIM first if you only care about visible content length.
Related formulas
LEFT()
Returns a substring from the beginning of a specified string.
RIGHT()
Returns a substring from the end of a specified string.
MID()
Returns a segment of a string starting at a given position, for a given length.
Used by
MID()
Returns a segment of a string starting at a given position, for a given length.
More Text formulas →Keyboard shortcuts for Sheets →