Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

CONCATENAR

On this page (10)

Joins texts.

FieldValue
CategoryText
TypeScalar (operates value by value)
Arity2 or more arguments
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: CONCATENAR. Accepted aliases (case-insensitive): concatenate, concat.

Syntax#

code
CONCATENAR(expr; arg2; …)

All arguments are expressions.

Returns#

Text.

Null handling#

A blank argument goes in as empty text (doesn't break the join).

Evaluation context#

Scalar — evaluated on the result of the arguments (in calculated columns, it runs row by row).

Differences from DAX#

  • DAX equivalent: CONCATENATE
  • Compatibility: DIFFERS from DAX — different semantics, watch out
  • Note: Joins N texts; DAX CONCATENATE accepts only 2 (or use the & operator).

Examples#

code
CONCATENAR(uf; " - "; canal)

Example with values#

Input: "SP", " - ", "loja".

code
CONCATENAR("SP"; " - "; "loja")  →  "SP - loja"

Expected result: "SP - loja"

Business example#

Build a “state - channel” label for the chart legend.

Common errors#

Typos in a column name, an incompatible type, or an invalid argument become a friendly message (pt-BR) — the engine never silently returns a wrong number.


← Back to the formula index

Related links