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