Function: Concat

Combine text from multiple strings

Use this function to combine text from multiple individual strings or list of strings.

Syntax	Operator	Description	Example
Concat(Text1 [,Text2])	&	Combines multiple strings into a single string

Arguments

For more information on arguments, see the table below.

Argument	Type	Description
Text1	Required	The first item to join. The item can be a text value, number, or cell reference.
Text2	Optional	Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters.

Example

Assume that variable JamType = Apricot:

• Concat(JamType, “jam”, “!”): Apricotjam!
• Concat(JamType, " ", “jam”, “!”): Apricot jam!
• Concat(JamType, " jam”, “!”): Apricot jam!
• Concat("My favorite jam is ”, JamType, "!"): My favorite jam is Apricot!
• Concat(List(“Blackberry “, “ is “, “ good”, “too!”)): Blackberry is good too!