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