Author: Oscar Cronquist Article last updated on May 11, 2022

The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the CONCAT function in Excel 2016, although it still exists for compatibility with earlier Excel versions.

The CONCATENATE function may be removed in a future Excel version, I recommend you use the CONCAT function or the more advanced TEXTJOIN function instead.

Formula in cell D3:


You cannot use a cell range as an argument, only cell references to single cells are allowed.

Press and hold the CTRL key to quickly select multiple cells while entering arguments in the CONCATENATE function.

Excel Function Syntax

CONCATENATE(text1, [text2])


text1 Required. The argument can be a text value, number, or cell reference.
[text2] Optional. You can have up to 255 additional text strings to join.


The new TEXTJOIN function is a lot more versatile and easier to use, however, it is only available in Excel 365.

There is a workaround available for earlier Excel versions:

Recommended articles

Concatenate cell values
Joining multiple cell values in Excel is not easy, for example, the CONCATENATE function allows you to only reference a […]