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], …)
=CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.")
=CONCATENATE(B2, " ",C2)
String CONCATENATE function in Excel