Manuals/calci/CONCATENATE

Revision as of 20:31, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CONCATENATE'''(Text1, Text2..........) where, '''Text1, Text2....''' - are the text join to single text. ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

CONCATENATE(Text1, Text2..........)

where,

Text1, Text2.... - are the text join to single text.


It joins number of text strings into one text string.

Use plus(+) instead of CONCATENATE function to join text.

CONCATENATE


Lets see an example in (Column1, Row3)

=CONCATENATE("Smith","SMITH)

It returns SmithSMITH.

Consider an another example in (Column2,Row3)

=CONCATENATE(1,2)

CONCATENATE returns 12.


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 SmithSMITH
Row2
Row3 12
Row4
Row5
Row6