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.
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, …)
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')
=concat('first part', 'second part')
=concat(A, 'suffix')
=concat('prefix', A1, 'suffix')
0 Comments