ReferenceFunctionsText Functions

LENB

LENB: Returns text length using non-DBCS byte-compatible semantics.

Summary

In Formualizer's invariant locale, LENB delegates to LEN.

Examples

Length of text

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

3

FAQ

Does LENB count UTF-8 bytes?

No. In the invariant locale it matches LEN.

Runtime metadata

Category

Text

Signature

LENB(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/byte.rs

LEN

LEN: Returns the number of characters in a text value.

LOWER

Converts text to lowercase.

On this page

Summary Examples Related functions FAQ Does LENB count UTF-8 bytes?Runtime metadata