ReferenceFunctionsText Functions

LOWER

Converts text to lowercase.

Summary

Converts text to lowercase.

Remarks

Uses ASCII lowercasing semantics in this implementation.
Numbers and booleans are first converted to text.
Errors are propagated unchanged.

Examples

Lowercase letters

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

data pipeline

Boolean coerced to text

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

true

FAQ

How are booleans handled by LOWER?

Inputs are coerced to text first, so TRUE/FALSE become lowercase string values.

Runtime metadata

Category

Text

Signature

LOWER(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

LEN

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

MID

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

On this page

Summary Remarks Examples Related functions FAQ How are booleans handled by LOWER?Runtime metadata