LENGTH

Returns the number of characters in a text string, including spaces and special characters.

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.

Applying len function

Excel equivalent

Length