Text1: Specify the first item to be joined (Required) The CONCATENATE is used to join text from several cells. 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 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.įrom which CONCATENATE is the widely used one as it was available in the earlier versions of Office.
