Difference between revisions of "Manuals/calci/CONCATENATE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CONCATENATE'''(Text1, Text2..........) where, '''Text1, Text2....''' - are the text join to single text. ...") |
|||
| Line 1: | Line 1: | ||
| − | + | =CONCATENATE(Text1, Text2, ...)= | |
| − | + | *where, <math>Text1, Text2, ...</math> are text strings to join | |
| − | + | CONCATENATE() joins number of text strings to form one text string. | |
| − | + | == Description == | |
| + | CONCATENATE(Text1, Text2, ...) | ||
| − | + | For Example, | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | CONCATENATE | + | CONCATENATE("JOHN"," ","SMITH") returns ''JOHN SMITH'' |
| − | < | + | *This function joins number of strings into one string. |
| − | + | *Arguments <math>Text1, Text2, ...</math> 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 == | |
| + | <div id="4SpaceContent" class="zcontent" align="left"> | ||
| − | + | {| id="TABLE2" class="SpreadSheet blue" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | {| id=" | ||
|- class="even" | |- class="even" | ||
| class=" " | | | class=" " | | ||
| − | | | + | | ColumnA |
| − | | | + | | ColumnB |
| − | | | + | | ColumnC |
| − | | | + | | ColumnD |
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f " | Happy | |
| − | | class="sshl_f" | | + | | class=" " | Holidays! |
| − | | class=" | + | | class=" " | |
| − | | class=" " | | + | | class=" " | |
| − | | class=" " | | ||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | Apple |
| − | | class=" | + | | class=" " |Mango |
| − | + | | class=" " |Orange | |
| − | | | ||
| class=" " | | | class=" " | | ||
| + | |- class="odd" | ||
| + | | class="sshl_f" |1234 | ||
| + | | class=" " |ABCD | ||
| class=" " | | | class=" " | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
|- class="even" | |- class="even" | ||
| − | + | | class="ssh1_f" |This is a pen. | |
| − | | class=" | + | | class=" " |It is Black. |
| − | | class=" | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| − | | class=" | + | | class="ssh1_f" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
|} | |} | ||
| + | |||
| + | =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.''' | ||
| + | |||
| + | == See Also == | ||
| + | *[[Manuals/calci/REPLACE | REPLACE]] | ||
| + | *[[Manuals/calci/SUBSTITUTE | SUBSTITUTE]] | ||
| − | + | == Reference == | |
| − | + | *[http://en.wikipedia.org/wiki/Concatenation Concatenation] | |
Revision as of 14:13, 30 December 2013
CONCATENATE(Text1, Text2, ...)
- where, are text strings to join
are text strings to joinCONCATENATE() 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.