| Syntax: | CONCATENATE(argumentlist) |
| STRCAT(argumentlist) |
argumentlist = any combination of numbers, cells, or ranges
CONCATENATE returns the concatenation of all its arguments. For cell arguments, the actual formatted contents of the cell are used, even if the cell contains a numeric value.
STRCAT is a synonym for CONCATENATE.
Example:
CONCATENATE(``The bottom line is '', B3, ``!'') = ``The bottom line is 1!'', where B3 = 1
CONCATENATE(``The sum is '', SUM(I1..I5) = ``The sum is 4'', where I1..I5 = 1, 1, -4, 0, and 6
STRCAT(``The Word is '', PROPER(S3)) = ``The word is Boston'', where S3 = boston
Excel function: CONCATENATE