Difference between revisions of "Manuals/calci/CONCATENATE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
=CONCATENATE(Text1, Text2, ...)=
+
<div style="font-size:30px">'''CONCATENATE () '''</div><br/>
 
+
*Parameters are text strings to join
*where, <math>Text1, Text2, ...</math> are text strings to join
+
**CONCATENATE(), joins several text items into one text item.
 
 
CONCATENATE() joins number of text strings to form one text string.
 
  
 
== Description ==
 
== Description ==
CONCATENATE(Text1, Text2, ...)
+
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 <math>Text1, Text2, ...</math> can be text, numbers, array or cell references, or combination of all items.
+
*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

CONCATENATE

See Also

Reference