CONCAT
Combines the text from multiple ranges and/or strings
Syntax
CONCAT(text1, [text2], ...)
Parameters
- text1: Required. Text item to be joined. A string, or array of strings, such as a range of cells
- text2: Optional. Additional text items to be joined, up to 253
Example
=CONCAT(A1:A5, " ")