Difference between revisions of "Manuals/calci/CONCATENATE"
Jump to navigation
Jump to search
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =CONCATENATE( | + | <div style="font-size:30px">'''CONCATENATE () '''</div><br/> |
| − | + | *Parameters are text strings to join | |
| − | + | **CONCATENATE(), joins several text items into one text item. | |
| − | |||
| − | CONCATENATE() joins | ||
== Description == | == Description == | ||
| − | CONCATENATE( | + | CONCATENATE() |
| − | + | *Consider the following example in ZOS, | |
| − | + | *CONCATENATE("JOHN"," ","SMITH") returns ''JOHN SMITH'' | |
| − | |||
| − | CONCATENATE("JOHN"," ","SMITH") returns ''JOHN SMITH'' | ||
| − | |||
*This function joins number of strings into one string. | *This function joins number of strings into one string. | ||
| − | *Arguments | + | *Arguments can be text, numbers, array or cell references, or combination of all items. |
| − | *An ampersand( | + | *An ampersand(&) can also be used instead of CONCATENATE function. |
| − | e.g. | + | e.g. In Calci, if cell A1=JOHN and cell A2=SMITH, then |
=(A1&" "&A2) returns ''JOHN SMITH'' | =(A1&" "&A2) returns ''JOHN SMITH'' | ||
| − | * | + | *Text string should be enclosed in quotes. |
| − | *If any punctuation marks to be added between two strings should also be entered as argument. | + | *If any punctuation marks are to be added between two strings, they should also be entered as argument. |
| − | *If arguments are omitted, Calci displays | + | *If arguments are omitted, Calci displays a #NULL error message. |
== Examples == | == Examples == | ||
| Line 28: | Line 23: | ||
{| id="TABLE2" class="SpreadSheet blue" | {| id="TABLE2" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " |ColumnA |
| − | | | + | | class=" " |ColumnB |
| − | | ColumnB | + | | class=" " |ColumnC |
| − | | ColumnC | + | | class=" " |ColumnD |
| − | | ColumnD | ||
|- class="odd" | |- class="odd" | ||
| class="sshl_f " | Happy | | class="sshl_f " | Happy | ||
| Line 64: | Line 58: | ||
=CONCATENATE(A3&B3&"5678") : Returns '''1234ABCD5678''' | =CONCATENATE(A3&B3&"5678") : Returns '''1234ABCD5678''' | ||
=CONCATENATE(A4," ",B4) : Returns '''This is a pen. It is Black.''' | =CONCATENATE(A4," ",B4) : Returns '''This is a pen. It is Black.''' | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|ZWiPQINKvW8|280|center|CONCATENATE}} | ||
== See Also == | == See Also == | ||
| Line 71: | Line 69: | ||
== Reference == | == Reference == | ||
*[http://en.wikipedia.org/wiki/Concatenation Concatenation] | *[http://en.wikipedia.org/wiki/Concatenation Concatenation] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 12: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