Learn how to combine cells in Microsoft Excel using the concatenate function in this step-by-step tutorial.
Access the sample data that I use in this video here: https://1drv.ms/x/s!AmxrofZZlZ-whIZfJ…
The CONCATENATE function joins two or more text strings into one string.
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.
=CONCATENATE (text1, text2, [text3], …)
In this video, I use the latest version of Microsoft Excel that comes with Office 365. However, this should work with older versions of Excel as the concatenate function has been available in past versions of Excel.
Kevin Stratvert 