ReferenceFunctionsText Functions
LEN
LEN: Returns the number of characters in a text value.
Summary
Returns the number of characters in a text value.
Remarks
- Counts Unicode scalar characters, not bytes.
- Empty values return
0. - Non-text values are converted to their text form before counting.
- Errors are propagated unchanged.
Examples
Basic text length
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
5
Whitespace is counted
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
3
Related functions
FAQ
Does LEN ignore spaces?
No. LEN counts spaces and other visible characters as part of the total length.
Runtime metadata
Category
Text
Signature
LEN(arg1: Any)Arity
min 1, max 1
Arguments
arg1Any · Scalar
Caps
PURE
Source