Concatenate || & Function || Concatenation || Excel Formulas
Learn how to combine cells in Microsoft Excel using the concatenate function in this step-by-step tutorial.
Concatenate || & Function || Concatenation || Excel Formulas
The CONCATENATE and & 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 and & functions. 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], ...)
& function is very good and easy to use.
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.
See all Excel tutorial videos here:
• How to Separate First and Last Name in Exc...