Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. 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.
Syntax: CONCATENATE(text1, [text2], …)
=CONCATENATE(“Stream population for “, A2, ” “, A3, ” is “, A4, “/mile.”)
=CONCATENATE(B2, ” “,C2)
The first item to join. The item can be a text value, number, or cell reference.
Text2, … (optional)
Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters.
Merge with “&”
The ampersand (&) calculation operator lets you join text items without having to use a function.
For example, =A1 & B1 returns the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.