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

The CONCAT function concatenates values from multiple cells. There is, however, no delimiting character or a way to ignore empty arguments like the TEXTJOIN function.

Formula in cell D3:

=CONCAT(B3:B6)

Excel Function Syntax

CONCAT(text1, [text2],…)

Arguments

text1 Required. Values you want to combine.
[text2] Optional. Up to 254 additional arguments.

Comments

The TEXTJOIN function provides more functionality than the CONCAT function.

Recommended articles

How to use the TEXTJOIN function
The TEXTJOIN function is a relatively new function introduced in Excel 2019, it is like the CONCATENATE function on steroids […]