The CONCAT, CONCATENATE and TEXTJOIN functions are popular as text combining functions, which have been designed to combine a range of strings that contain parts of text, phrases or numbers.
From which CONCATENATE is the widely used one as it was available in the earlier versions of Office. The CONCAT and TEXTJOIN functions have recently been introduced and are only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).
The CONCATENATE is used to join text from several cells.
The syntax is explained below: