CONCAT

Concatena una o més cadenes

CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M.

When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate.

Sintaxi

CONCAT( String 1 [; String 2 [; … [; String 255]]])

String 1, String 2, … , String 255 are strings, references to cells or to cell ranges of strings.

Exemples

=CONCAT("Hello ", A1:C3) concatenates the string "Hello" with all strings in range A1:C3.

Informació tècnica

Aquesta funció és disponible des de la versió 5.2 del LibreOffice.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.CONCAT

CONCAT wiki page.

TEXTJOIN

CONCATENATE