Author: Oscar Cronquist Article last updated on July 23, 2018

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:

=CONCATENATE(B3,B4,B5,B6)

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])

Arguments

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.

Comments

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:

Quickly concatenate values into one cell [No VBA]

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