ReferenceFunctionsText Functions

MIDB

MIDB: Extracts text from the middle using non-DBCS byte-compatible semantics.

Summary

In Formualizer's invariant locale, MIDB delegates to MID.

Examples

Middle byte-compatible characters

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

bcd

FAQ

How are byte positions interpreted?

In the invariant locale, positions are character positions matching MID.

Runtime metadata

Category

Text

Signature

MIDB(arg1, arg2, ... argN: Any)

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

Arity

min 3, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

MID

MID: Returns a substring starting at a 1-based position.

NUMBERVALUE

NUMBERVALUE: Converts locale-delimited text to a number.

On this page

Summary Examples Related functions FAQ How are byte positions interpreted?Runtime metadata