How to use the Excel LEN function

The LEN function in Excel counts characters in a string. I mainly use it when I need to extract text from a string. The Excel LEN function comes in handy when the number of characters in a string is indefinite.

Syntax: =LEN(text)

The LEN function syntax has the following arguments:

  • text – The text for which to calculate length.

Example: Let’s look at some Excel LEN function examples and explore how to use the LEN function as a worksheet function in Microsoft Excel:

Excel LEN Function 1 - How to use the Excel LEN function

Syntax: =LEN(A2)

Result:

Excel LEN Function - How to use the Excel LEN function

Syntax: =LEN(A3)
Result: 18

Syntax: =LEN(A4)
Result: 13

Syntax: =LEN(A5)
Result: 26

Syntax: =LEN(A6)
Result: 7

Syntax: =LEN(A7)
Result: 4

READ:  How to use the Excel NUMBERVALUE function

Add a Comment

Your email address will not be published. Required fields are marked *