Related Topics: | ||
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".
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.