This function combines multiple text strings or numbers into one text string.
CONCATENATE(text1,text2,...)
The arguments can be strings, formulas that return a string, or references to cells containing a string. Up to 255 arguments may be included.
Accepts string data for both arguments. Returns string data.
CONCATENATE(B4,D5)
CONCATENATE(R4C2,R5C4)
CONCATENATE(""Gold "", ""Medal"") gives the result Gold Medal