LEN function

Category: Text functions

What does this function do?

Returns the number of characters in a string.

Syntax:

LEN(text)

• Text (required): The text to get the number of characters

Examples:

=LEN(“The wizard of Excel”)=19

If A1=”The wizard of Excel” 

=LEN(A1)=19