Len Excel Formula




Excel Formulas > Text Functions > LEN

« Left | Len | Lower »

What is the use of Len formula?

Tells you the length of a given text


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

Buy Excel Formula E-book | Learn more about Excel Len Formula

More Text Functions : Concatenate | Find | Left | Len | Lower | Mid | Proper | Rept | Substitute | Trim | Upper | Value

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook