To use this function, choose Calc > Calculator.

Identifies the number of characters in a string of text.

Syntax

LEN(text)

For text, specify the text or the column of text values.

Example

Column Calculator expression Result
C1 contains "Defective" LEN(C1) 9