Use

The Concat() function joins multiple text values together into one text value.

The input can either be multiple individual text values, or an array that contains text values.

Note that you can also use the + operator to concat text values, e.g. "abc" + "def" + "ghi"  = "abcdefghi".

Examples

• Concat("abc", "def", "ghi")  = "abcdefghi"
• Concat(["one", "two", "three"])  = "onetwothree"
• Concat(B3:B9)  = "Do you wish me a good morning?"