CONCATENATE

This function joins separate pieces of text into one item.

Syntax

=CONCATENATE(Text1,Text2,Text3...Text30)

Up to thirty pieces of text can be joined.

Note You can achieve the same result by using the & operator.