LEN function

LEN returns the number of characters in a text string.

Syntax

LEN(text)

Text     is the text whose length you want to find. Spaces count as characters.

Examples

Col1	Formula	Description (Result)
Phoenix, AZ	=LEN([Col1])	Length of the string (11)
	=LEN([Col1])	Length of the string (0)
A     One	=LEN([Col1])	Length of the string, which includes 5 spaces (9)