LEN returns the number of characters in a text string.
The LEN function syntax has the following arguments:
- value (Required) The text whose length you want to find. Spaces count as characters.
Field 1: ="Phoenix, AZ"
Field 2: =""
Field 3: =" One "
|=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 10 months ago