Jump To Right Section
Show
Why string concatenate
Concatenation is the process of appending one string to the end of another string in Excel. In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCATENATE function. Although the concatenate function is still available for backward compatibility, you should consider using concatenate from now on. This is because concatenate may not be available in future versions of Excel.
Syntax: CONCATENATE(text1, [text2], …)
For example:
1 2 3 4 5 |
=CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.")
=CONCATENATE(B2, " ",C2) |
String CONCATENATE function in Excel
Leave a Comment