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 skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT INSIDERS >

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×