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.
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: