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.
Included in the group of six functions released by Excel 2016 is a very valuable function; TEXTJOIN.