ReferenceFunctionsText Functions

CONCAT

Concatenates multiple values into one text string.

Summary

Concatenates multiple values into one text string.

Remarks

Accepts one or more arguments.
Ranges and arrays are flattened in row-major order.
Blank values contribute an empty string.
Numbers and booleans are coerced to text.
Errors are propagated as soon as encountered.
Results longer than 32,767 characters return #VALUE!.

Examples

Join text pieces

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

Q1-2026

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 (Range))

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

Arity

min 1, max variadic

Arguments

arg1

Any · Range

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 function that joins multiple scalar values as text.

On this page

Summary Remarks Examples Related functions FAQ Do blank arguments add separators or characters?Runtime metadata