The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the CONCAT function in Excel 2016, although it still exists for compatibility with earlier Excel versions.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Text'
The CONCATENATE function function is one of many functions in the 'Text' category.