Formualizer Docs
ReferenceFunctionsText Functions

CONCATENATE

CONCATENATE: Legacy alias for `CONCAT` that joins multiple values as text.

Summary

Legacy alias for CONCAT that joins multiple values as text.

Remarks

  • Semantics match CONCAT in this implementation.
  • 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
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
Jan-2026
Boolean coercion
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
Flag:TRUE

FAQ

Is CONCATENATE behavior different from CONCAT here?

No. In this engine CONCATENATE uses the same join semantics as CONCAT.

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

SummaryRemarksExamplesRelated functionsFAQIs CONCATENATE behavior different from CONCAT here?Runtime metadata