writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − '''CONCATENATE'''(Text1, Text2..........)+ − where,+ − '''Text1, Text2....''' - are the text join to single text.+ + − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left">It joins number of text strings into one text string.</div> − ---- − <div id="7SpaceContent" class="zcontent" align="left">Use plus(+) instead of CONCATENATE function to join text.</div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − + − + − ----+ − <div id="8SpaceContent" class="zcontent" align="left">+ − Lets see an example in (Column1, Row3)+ − <nowiki>=CONCATENATE("Smith","SMITH)</nowiki>+ + + + − It returns SmithSMITH.+ + − Consider an another example in (Column2,Row3)+ − − <nowiki>=CONCATENATE(1,2)</nowiki> − − CONCATENATE returns 12. − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − − + − + − + − + − | class=" " | Row1+ − + − + − + − − + − + − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>+ − + + + − |- class="odd" − | Row3 − | class="sshl_f " | − | class="sshl_f" | 12 − | class=" " | − | Row4+ − + − − + − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | + + + + + + + + + − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----+
Manuals/calci/CONCATENATE (view source)
Revision as of 19:13, 30 December 2013
, 19:13, 30 December 2013no edit summary
=CONCATENATE(Text1, Text2, ...)=
*where, <math>Text1, Text2, ...</math> are text strings to join
CONCATENATE() joins number of text strings to form one text string.
== Description ==
CONCATENATE(Text1, Text2, ...)
For Example,
CONCATENATE
CONCATENATE("JOHN"," ","SMITH") returns ''JOHN SMITH''
</div></div>
*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.
*An ampersand('&') can also be used instead of CONCATENATE function.
e.g. If cell A1=JOHN and cell A2=SMITH, then
=(A1&" "&A2) returns ''JOHN SMITH''
*If a text string is entered as an argument, it should be enclosed in quotes.
*If any punctuation marks to be added between two strings should also be entered as argument.
*If arguments are omitted, Calci displays and #NULL error message.
== Examples ==
<div id="4SpaceContent" class="zcontent" align="left">
{| id="TABLE2" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class=" " |
| class=" " |
| Column1
| ColumnA
| class=" " | Column2
| ColumnB
| class=" " | Column3
| ColumnC
| Column4
| ColumnD
|- class="odd"
|- class="odd"
| class="sshl_f " | Happy
| class="sshl_f" | SmithSMITH
| class=" " | Holidays!
| class=" sshl_f " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="even"
| class=" " | Row2
| class="sshl_f" | Apple
| class=" SelectTD ChangeBGColor SelectTD" |
| class=" " |Mango
| class=" " |Orange
|
| class=" " |
| class=" " |
|- class="odd"
| class="sshl_f" |1234
| class=" " |ABCD
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="even"
| class="ssh1_f" |This is a pen.
| class=" " |
| class=" " |It is Black.
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " | Row5
| class="ssh1_f" |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}
|}
=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.'''
== See Also ==
*[[Manuals/calci/REPLACE | REPLACE]]
*[[Manuals/calci/SUBSTITUTE | SUBSTITUTE]]
== Reference ==
*[http://en.wikipedia.org/wiki/Concatenation Concatenation]