CONCAT function/text/scalc/01/func_concat.xhpCONCAT function
CONCAT
Concatenates one or more stringsCONCAT 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.CONCAT( )=CONCAT("Hello ", A1:C3) concatenates the string "Hello" with all strings in range A1:C3.CONCATENATE