Use CONCAT to combine a range of text cells.

Compared to its predecessor CONCATENATE, CONCAT can join multiple cells by simply typing the cell range.

The function is available on Excel 2019 and Office 365.


=CONCAT(text1, …)

text1 – The range of cells we would like to concatenate

Please note that we can type in additional ranges after the comma (,)

Practice CONCAT Function

And here is how it works: