LEN

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. This function is commonly used to measure text length, validate input, and prepare data for further processing.

Syntax

LEN(text)

Arguments

• text: The text string or reference whose length you want to calculate.

Return value

Returns the total number of characters in the text string.

Example

LEN([Product Name])

Calculates the number of characters in each value of the Product Name field, including spaces and special characters.

Excel equivalent

LENGTH