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:

**Syntax**: =LEN(A2)

**Result**:

**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