From ZCubes Wiki
Revision as of 06:54, 22 March 2017 by Jayaram (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


CONCAT(Text1, Text2, ...)

  • This function joins number of strings into one string.
  • Arguments 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.


=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


See Also