Learn how to use Len Excel formula

LEN

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.

ExampleThis 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.