STRCAT(<List>)

 

Description

This function 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

 

<List>

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.