ReferenceFunctionsText Functions

CONCATENATE

CONCATENATE: Legacy function that joins multiple scalar values as text.

Summary

Legacy function that joins multiple scalar values as text.

Remarks

Range and array arguments use only their top-left value.
Blank values contribute an empty string.
Numbers and booleans are coerced to text.
Errors are propagated as soon as encountered.

Examples

Legacy concatenate behavior

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

Jan-2026

FAQ

Is CONCATENATE behavior different from CONCAT here?

Yes. CONCAT expands ranges and arrays, while legacy CONCATENATE uses only the top-left value.

Runtime metadata

Category

Text

Signature

CONCATENATE(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/trim_case_concat.rs

CONCAT

Concatenates multiple values into one text string.

DOLLAR

DOLLAR: Formats a number as currency text.

On this page

Summary Remarks Examples Related functions FAQ Is CONCATENATE behavior different from CONCAT here?Runtime metadata