Manuals/calci/CONCATENATE

From ZCubes Wiki
Revision as of 13:08, 28 April 2015 by Swapna (talk | contribs)
Jump to navigation Jump to search

CONCATENATE(Text1, Text2, ...)

  • where, are text strings to join

CONCATENATE() joins number of text strings to form one text string.

Description

CONCATENATE(Text1, Text2, ...)

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