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 available in Excel 2019+ and Excel 365.

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass