Description
Joins several text strings into one string.
Syntax
CONCATENATE ( arg1, "arg2", ... )
| Parameter | Description |
|---|---|
| arg1, arg2, ... |
Either text enclosed in quotes or references to a source field. Up to 30 arguments to be joined into a single text item. The text items can be strings, numbers, or single-cell references. |
Remarks
The "&" operator can be used instead of CONCATENATE to join text items.
Note: The CONCATENATE function has a 255 character limit for concatenated strings. Any additional characters are truncated. To concatenate long strings, use the "&" operator.
Examples
The following example returns "Sale Price". It is the same as typing "Sale"&" "&"Price":
CONCATENATE ("Sale ", "Price")
In the following example, a source row contains the following values, S2 contains "extruder1", S5 contains " gaskets", and S8 contains the number 15. The following example returns "Inventory currently holds 15 gaskets for extruder1":
CONCATENATE ("Inventory currently holds ", S8, " ", S5," for ", S2)
In the following example, we want to concatenate two text fields where one field may be null. Use ISERROR to test for the null and set it to a space or a zero length string.
S14&IF(ISERROR(S15),"",S15)
See also