In this post, we want to discuss a nice function to string concatenate in Excel. Before we get started, if you want to know about rescue antivirus, please go through the following article: F-Secure Rescue Antivirus.
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 concatenated 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