Article updated on June 16, 2018

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.

How to use the TEXTJOIN function

The TEXTJOIN function is a new function for office 365 subscribers, it is like the CONCATENATE function on steroids or what the CONCATENATE function […]