How to join text and numbers using CONCATENATE Function

Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.