The CONCAT function combines the text from multiple cells, ranges and/or text strings, without delimiters.
Syntax:
=Concat(text string 1, text string 2, text string…)
Text string 1. First text string to be combined
Text string 2. Second text string to be combined