CONCATENATE(Text1, Text2, ...)
- where, are text strings to join
CONCATENATE() joins number of text strings to form one text string.
Description
CONCATENATE(Text1, Text2, ...)
For Example,
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. If cell A1=JOHN and cell A2=SMITH, then
=(A1&" "&A2) returns JOHN SMITH
- If a text string is entered as an argument, it should be enclosed in quotes.
- If any punctuation marks to be added between two strings should also be entered as argument.
- If arguments are omitted, Calci displays and #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.