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. ...") |
|||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''CONCATENATE () '''</div><br/> |
| + | *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 == | |
| − | + | <div id="4SpaceContent" class="zcontent" align="left"> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | <div id=" | ||
| − | + | {| id="TABLE2" class="SpreadSheet blue" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | {| id=" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " |ColumnA |
| − | | | + | | class=" " |ColumnB |
| − | | class=" | + | | class=" " |ColumnC |
| − | | class=" " | | + | | class=" " |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.''' | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|ZWiPQINKvW8|280|center|CONCATENATE}} | ||
| + | |||
| + | == See Also == | ||
| + | *[[Manuals/calci/REPLACE | REPLACE]] | ||
| + | *[[Manuals/calci/SUBSTITUTE | SUBSTITUTE]] | ||
| + | |||
| + | == Reference == | ||
| + | *[http://en.wikipedia.org/wiki/Concatenation Concatenation] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 13:32, 15 August 2018
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