Best way to string CONCATENATE function in Excel

In this post, we want to discuss about 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

Table of Contents Hide

1) Why string concatenate

2) Syntax: CONCATENATE(text1, [text2], …)

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:


=CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.")

=CONCATENATE(B2, " ",C2)

=CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.")

=CONCATENATE(B2, " ",C2)

String CONCATENATE function in Excel

String CONCATENATE function in Excel

Why string concatenate

Syntax: CONCATENATE(text1, [text2], …)

You may also like

Leave a Reply Cancel reply