Formula Functions > Functions A to C > CONCATENATE |
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
This function is available in product version 1.0 or later.
CHAR | EXACT | Text Functions