CONCATENATE(Text1, Text2, ...)
CONCATENATE ()
- Parameters are text strings to join
- CONCATENATE(), joins several text items into one text item.
Description
CONCATENATE()
- Consider the following example in ZOS,
- CONCATENATE("JOHN"," ","SMITH") returns JOHN SMITH
- This function joins number of strings into one string.
- Arguments can be text, numbers, array or cell references, or combination of all items.
- An ampersand(&) can also be used instead of CONCATENATE function.
e.g. In Calci, if cell A1=JOHN and cell A2=SMITH, then
=(A1&" "&A2) returns JOHN SMITH
- Text string should be enclosed in quotes.
- If any punctuation marks are to be added between two strings, they should also be entered as argument.
- If arguments are omitted, Calci displays a #NULL error message.
Examples
| ColumnA | ColumnB | ColumnC | ColumnD |
| Happy | Holidays! | ||
| Apple | Mango | Orange | |
| 1234 | ABCD | ||
| This is a pen. | It is Black. | ||
=CONCATENATE(A1," ",B1) : Returns Happy Holidays! =CONCATENATE(A2,",",B2,",",C2) : Returns Apple,Mango,Orange =CONCATENATE(A3&B3&"5678") : Returns 1234ABCD5678 =CONCATENATE(A4," ",B4) : Returns This is a pen. It is Black.
Related Videos
See Also
Reference