Manuals/calci/CONCATENATE
Jump to navigation
Jump to search
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 |
