Excel LEN function can be of great use during the data validation.

Many a time, we might be required to limit the text size to a particular length, which can be determined using this function.

1. What is the Excel LEN Function?

2. What is the Syntax?

3. How to use it with an example?

*1. What is the EXCEL LEN Function?*

*1. What is the EXCEL LEN Function?*

The LEN function can be used to find the length of the supplied text, including the numbers while ignoring the applied formatting if any.

*2. What is the Syntax?*

*2. What is the Syntax?*

**=LEN(text)**

**text**= (Required) Text for which the length has to be calculated.

*Note :*

- If any number formatting is applied to the cell(i.e currency and punctuations), it will be ignored by the LEN.
- Dates will also return a length but in its integer representation (i.e. January 1, 1900, which is stored as number 1)

*3. How to use it with an example?*

*3. How to use it with an example?*

Let’s find the lengths of different items of the given data set.

**Explained** =LEN(A2)

A2 = Reference to the cell ,for which we have to find the length.

*Hope it has helped you… *

Advertisements