Concat

Description of formula:
Joins several text strings into one text. You can pass any number of arguments of type Text, arrays of text values or cell ranges.

Syntax:
concat(text, …)

Parameters:

text

(type: Text / array of Texts) (multiple parameter) Texts that you want to concatenate

Returned type:

Text

Examples:
=concat('first part', 'second part')
=concat(A, 'suffix')
=concat('prefix', A1, 'suffix')

 

Available from version 2.3
Merging attachment type cells
Formula allows you to merge the contents of cells containing attachments. You can indicate a specific attachment type cell or attachment type sections.

Syntax:
concat(attachment array, …)

Parameters:

attachment array

(type: Address of attachment type cell / attachment type section) (multiple parameter) The array of attachments you want to concatenate

Returned type:

Array of attachments

Examples:
=concat(section12.a2,section14.b1)
=concat(section32.a1,section35)
=concat(section14.a1,last(section15.a))