Difference between revisions of "Manuals/calci/CONCATENATE"
Jump to navigation
Jump to search
(One intermediate revision by the same user 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, | |
− | 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(&) can also be used instead of CONCATENATE function. | *An ampersand(&) can also be used instead of CONCATENATE function. | ||
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