Formualizer Docs
ReferenceFunctionsText Functions

LEFTB

LEFTB: Returns the leftmost characters using non-DBCS byte-compatible semantics.

Summary

In Formualizer's invariant locale, LEFTB delegates to LEFT.

Examples

Left byte-compatible characters
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
he

FAQ

Does LEFTB split UTF-8 bytes?

No. It follows the non-DBCS behavior and delegates to LEFT.

Runtime metadata

Category

Text

Signature

LEFTB(arg1…: Any)

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

LEFT

Returns the leftmost characters from a text value.

LEN

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

On this page

SummaryExamplesRelated functionsFAQDoes LEFTB split UTF-8 bytes?Runtime metadata