Description
Returns the number of characters in a Text.
Syntax
LEN(Text)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Text (required) | Text | Any Dimensions | Text to get the number of characters from. |
Returns
| Type | Dimensions |
|---|---|
| Integer | Dimensions of Text |
Examples
| Formula | Result | Description |
|---|---|---|
| LEN(“text”) | 4 | |
| LEN(“This is a sentence”) | 18 | There are 18 characters in the text, including the spaces. |
See also
Excel: LEN