Len

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.

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