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.
In the screen above, the formulas used for concatenation are:
=B6&" and pears" =B7&" apples" ="The term is "&12&" months" ="Sale ends "&TEXT(B8,"mmmm d")
Note that in the last example, we are using the TEXT function to format the date in B8 as a date in "mmm d" format.
Concatenation with functions
Excel contains three functions you can also use for concatenation: the CONCATENATE function, the CONCAT function, and the TEXTJOIN function. CONCAT and TEXTJOIN are new functions available in Office 365 and Excel 2019.