 |
 |
|
 |
 |
|
 |
 |
 |
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-2019. HBM Prenscia Inc. ALL RIGHTS RESERVED.
 |
E-mail Link |