Formula Engine Reference Guide
 

 

Back to Class Index

 

STRCAT(argumentlist)

Description
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.
 
Parameters
argumentlist
Any combination of numbers, cells, or ranges
 
Examples
STRCAT("The bottom line is ", B3, "!") = "The bottom line is 1!"
where B3 = 1
 
STRCAT("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