Author: Oscar Cronquist Article last 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:


Excel Function Syntax

CONCAT(text1, [text2],…)


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


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 […]

How to use the TEXTJOIN function