Difference between revisions of "Manuals/calci/CONCATENATE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CONCATENATE'''(Text1, Text2..........) where, '''Text1, Text2....''' - are the text join to single text. ...") |
(No difference)
|
Revision as of 02:31, 25 October 2013
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 |
