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)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×