CONCATENATE

Used only in ReliaSoft Workbooks

Description: Joins several text strings into one text string.

Syntax: CONCATENATE (Text1, Text2, ...)

  • Text1, Text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

Remarks:

  • The “&” operator can be used instead of CONCATENATE to join text items.

Example:

  • CONCATENATE(“Total", " ", "Value") = "Total Value". This is equivalent to typing "Total"&" "&"Value".

Related Topics and Links