CONCAT joins or concatenates the text strings together. The str1.. str9 parameters can be quoted strings ("Sunny"), cell references (B5), or formulas that return a string (VT(1,1)).
SYNTAX:
Concat(str1,str2,...str9)
str1..str9: Text to be joined together. Can be quoted strings ("Sunny"), cell references (B5), or formulas that return a string (VT(1,1)).
NOTES:
Returns a Text string. Cell type will be changed to Text when using this formula.
EXAMPLES:
CONCAT("Hach ","Be Right") = Hach Be Right