Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Created page with "<div style="font-size:30px">'''CONCAT()'''</div><br/> == Description == CONCAT(Text1, Text2, ...) *This function joins number of strings into one string. *Arguments <math>Te..."
<div style="font-size:30px">'''CONCAT()'''</div><br/>
== Description ==
CONCAT(Text1, Text2, ...)
*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.
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 ==
=CONCAT("Happy"," ","Holidays!") : Returns '''Happy Holidays!'''
=CONCAT("Apple",",","Mango",",","Orange") : Returns '''Apple,Mango,Orange'''
=CONCAT("1234","ABCD","5678") : Returns '''1234ABCD5678'''
=CONCAT("This is a pen."," ","It is Black.") : 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 ]]
== Description ==
CONCAT(Text1, Text2, ...)
*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.
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 ==
=CONCAT("Happy"," ","Holidays!") : Returns '''Happy Holidays!'''
=CONCAT("Apple",",","Mango",",","Orange") : Returns '''Apple,Mango,Orange'''
=CONCAT("1234","ABCD","5678") : Returns '''1234ABCD5678'''
=CONCAT("This is a pen."," ","It is Black.") : 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 ]]