Concatenation refers to the operation of joining values together to create a text string.
CONCAT and TEXTJOIN are new functions available in Office 365 and Excel 2019.
Concatenation
Concatenation refers to the operation of joining values together to create a text string. In Excel, you can concatenate with the concatenation operator, which is an ampersand (&) or by using one of several functions for concatenation.
