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!
Updated about a year ago