LEN returns the number of characters in a text string.
Syntax
LEN(value)
The LEN function syntax has the following arguments:
- value (Required) The text whose length you want to find. Spaces count as characters.
Example
Field 1: ="Phoenix, AZ"
Field 2: =""
Field 3: =" One "
| Formula | Description | Result |
|---|---|---|
| =LEN([Field 1]) | Length of the first field | 11 |
| =LEN([Field 2]) | Length of the second field | 0 |
| =LEN([Field 2]) | Length of the third field, which includes 5 spaces before and 3 after the word "One" | 11 |
Updated about 1 year ago