CONCATENATE
Joins several text items into one text item. Replaced by CONCAT.
Syntax
CONCATENATE(text1, [text2], ...)
Parameters
- text1: Required. The first item to join
- text2: Optional. Additional text items, up to 255
Example
=CONCATENATE("Hello", " ", "World")