Manuals/calci/CONCATENATE
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 |