CONCAT

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn’t provide delimiter or IgnoreEmpty arguments. 

Syntax

CONCAT(text1, [text2],…)

The CONCAT function syntax has the following arguments:

• text1    Required. Text item to be joined. A string, or array of strings, such as a range of cells.
• text2, …    Optional. Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.

Specifics

• If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error.

Examples

	A’s	B’s
	a1	b1
	a2	b2
	a3	b3
Formula	Description	Result
=CONCAT(B2:C4)	Joins all the data from the cells in the range.	a1b1a2b2c3b3

Data	First Name	Last name
brook trout	Andreas	Hauser
species	Fourth	Pine
32
Formula	Description	Result
=CONCAT(“Stream population for “, A2,” “, A3, ” is “, A4, “/mile.”)	Creates a sentence by joining the data in column A with other text.	Stream population for brook trout species is 32/mile.
=CONCAT(B2,” “, C2)	Joins three things: the string in cell B2, a space character, and the value in cell C2.	Andreas Hauser
=CONCAT(C2, “, “, B2)	Joins three things: the string in cell C2, a string with a comma and a space character, and the value in cell B2.	Hauser, Andreas
=CONCAT(B3,” & “, C3)	Joins three things: the string in cell B3, a string consisting of a space with ampersand and another space, and the value in cell C3.	Fourth & Pine
=”laugh” & “ out “ & “loud”	Also concatenation can also be acheived using the ‘&’ operator.	laugh out loud