LEN (Returns the number of characters in a text string)

What Does It Do?

This function counts the number of characters, including spaces and numbers, in a piece of text.

Syntax

=LEN(Text)

Formatting

No special formatting is needed.

Example

This example shows how the =LEN() function is used in a formula which extracts the second name from a text entry containing both first and second names.