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   "

FormulaDescriptionResult
=LEN([Field 1])Length of the first field11
=LEN([Field 2])Length of the second field0
=LEN([Field 2])Length of the third field, which includes 5 spaces before and 3 after the word "One"11