Manuals/calci/CONCATENATE

CONCATENATE(Text1, Text2, ...)

• where, $Text1,Text2,...$ are text strings to join

CONCATENATE() joins number of text strings to form one text string.

Description

CONCATENATE(Text1, Text2, ...)

For Example,

CONCATENATE("JOHN"," ","SMITH") returns JOHN SMITH

• This function joins number of strings into one string.
• Arguments $Text1,Text2,...$ 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

	ColumnA	ColumnB	ColumnC	ColumnD
Happy	Holidays!
Apple	Mango	Orange
1234	ABCD
This is a pen.	It is Black.

=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

• REPLACE
• SUBSTITUTE

Reference

• Concatenation