next up previous contents index
Next: CONFIDENCE Up: A. Function Reference Previous: COLS, COLUMNS   Contents   Index


CONCATENATE, STRCAT

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


next up previous contents index
Next: CONFIDENCE Up: A. Function Reference Previous: COLS, COLUMNS   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003