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)

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

×