Formualizer Docs
ReferenceFunctionsText Functions

CONCAT

Concatenates multiple values into one text string.

Summary

Concatenates multiple values into one text string.

Remarks

  • Accepts one or more arguments.
  • Blank values contribute an empty string.
  • Numbers and booleans are coerced to text.
  • Errors are propagated as soon as encountered.

Examples

Join text pieces
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
Q1-2026
Concatenate with blanks
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
AB

FAQ

Do blank arguments add separators or characters?

No. CONCAT appends each value directly, and blanks contribute an empty string.

Runtime metadata

Category

Text

Signature

CONCAT(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

CODE

Returns a numeric code for the first character in a text string.

CONCATENATE

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

On this page

SummaryRemarksExamplesRelated functionsFAQDo blank arguments add separators or characters?Runtime metadata