Skip to main content

LEN/LENB function

The LEN/LENB function is one of the text and data functions. Is used to analyse the specified string and return the number of characters it contains. The LEN function is intended for languages that use the single-byte character set (SBCS), while LENB - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

Syntax​

LEN(text)

LENB(text)

The LEN/LENB function has the following argument:

ArgumentDescription
textThe text whose length you want to find.

Notes​

How to apply the LEN/LENB function.

Examples​

The figure below displays the result returned by the LEN function.

LEN/LENB Function