[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

LENB

Syntax:

LENB ( string )

Description: Determines the number of bytes in string. (LENB is intended for use with languages that use the double-byte character set (DBCS), whereas LEN3.17.7.191) is intended for use with languages that use the single-byte character set (SBCS).)

Arguments:

Name

Type

Description

string

text

Designates the string whose length is to be found.

 

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

[Example: Assuming 1-byte characters:

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

end example]