CONCAT

Concatenates one or more strings

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.

tip

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


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.

Ens cal la vostra ajuda!