[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
CONCATENATE ( argument-list )
Description: Makes a string that is the concatenation of all the strings corresponding to the arguments in argument-list, taken left-to-right.
Arguments:
|
Name |
Type |
Description |
|
argument-list |
Each argument in argument-list shall designate a string. |
Return Type and Value: text – The concatenated string.
[Example:
CONCATENATE("text") results in text
CONCATENATE("The total is ",A10," units") results in The total is 43 units, when A10 contains 43
CONCATENATE(3," + ",4," = ",3+4) results in 3 + 4 = 7
end example]