[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 LENB (§3.17.7.192) is intended for use with languages that use the double-byte character set (DBCS).)
Arguments:
Name |
Type |
Description |
string |
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]