LEN

Name

Length

Description

Returns the number of characters in a text string.

Syntax

LEN(value)

Remarks

The value argument is the text whose length you want to find. Spaces count as characters.

Arguments must be strings or cell references to string values.

Data Type

Accepts string data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

fpSpread1.Formula = "LEN(""FarPoint Technologies, NC"")" equals 25