Len

What is the use of Len formula?

Tells you the length of a given text

LEN returns the number of characters in a text string.
LENB returns the number of bytes used to represent the characters in a text string.

 Syntax of Len formula:

len(of this text)

Examples of Excel Len formula:

len("hello") = 5
len(A1) = length of the value in cell A1


Formula Description (Result)
=LEN(A2) Length of the first string (11)
=LEN(A3) Length of the second string (0)
=LEN(A4) Length of the third string, which includes 5 spaces (8)

Comments

Popular posts from this blog

Writing Systems Of The World

International Phonetic Alphabet

GRBL Feed Rate