CONCATENATE function
Summary
Joins several text items into one text item
Syntax
CONCATENATE(text1, [text2], ...)
Example
=CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.")
=CONCATENATE(B2, " ", C2)
=CONCATENATE(C2, ", ", B2)
=CONCATENATE(B3, " & ", C3)
=B3 & " & " & C3
=CONCATENATE(B2, " ", C2)
=CONCATENATE(C2, ", ", B2)
=CONCATENATE(B3, " & ", C3)
=B3 & " & " & C3