Note:CONCATENATE
Description
CONCATENATE joins several text strings into one string.
Syntax
CONCATENATE ( text1, text2, .... )
|
Parameter |
Description |
|
text1, text2, ... |
Up to 30 text items 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.
Examples
The following example returns "Sale Price". It is the same as if you type "Sale "&"Price":
CONCATENATE ("Sale", "Price")
Suppose in an inventory worksheet, C2 contains "extruder1", C5 contains " gaskets", and C8 contains the number 15. The following example returns "Inventory currently holds 15 gaskets for extruder1":
CONCATENATE ("Inventory currently holds", C8, " ", C5," for", C2)
Note:
If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.
Also, see