CONCATENATE function
CONCATENATE combines several text strings into one string.
Syntax
CONCATENATE(text 1, ...text 30)
text 1, text 2, and so on represent up to 30 text strings that are to be combined into one string.
Example
CONCATENATE("Good ","Morning ","Mrs.","Doe") returns Good Morning Mrs. Doe.