[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

LEN

Syntax:

LEN ( string )

Description: Determines the number of characters in string. (LEN is intended for use with languages that use the single-byte character set (SBCS), whereas LENB3.17.7.192) is intended for use with languages that use the double-byte character set (DBCS).)

Arguments:

Name

Type

Description

string

text

Designates the string whose length is to be found.

 

Return Type and Value: number – The number of characters in string.

[Example:

LEN("abc") results in 3
LEN(A10) results in 3, when A1 contains abc

end example]