# LENGTH

The **LEN** function returns the total number of characters in a text string, including letters, numbers, spaces, and special characters. It is commonly used to measure text length, validate input, or prepare data for further processing.

### Syntax

```
LEN(text)
```

### Arguments

text- The text string or cell reference whose length you want to calculate. Required.

### **Return value**

A numeric value representing the total number of characters in the text.

### **Example**

```
LEN([Product Name])
```

In the example below, the **LEN** function calculates the length of the *First Product Name* field. The function returns the number of characters in each product name, including letters, spaces, and punctuation. This helps analyze or filter data based on text length.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fm08tK7OdcG5DLwRqnu1y%2Fimage.png?alt=media&#x26;token=915538ef-0fe9-45d9-b3cf-8635e97c3f83" alt=""><figcaption><p>Applying len function</p></figcaption></figure>

### **Excel equivalent**

[**Length**](https://support.microsoft.com/en-us/office/len-function-29236f94-cedc-429d-affd-b5e33d2c67cb)