- Document Solutions for Excel, Java Edition Overview
- Key Features
- Getting Started
- Features
- Templates
-
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
-
Text Functions
- ARRAYTOTEXT
- ASC
- BAHTTEXT
- CHAR
- CLEAN
- CODE
- CONCAT
- CONCATENATE
- DBCS
- DOLLAR
- EXACT
- FIND
- FINDB
- FIXED
- JIS
- LEFT
- LEFTB
- LEN
- LENB
- LOWER
- MID
- MIDB
- NUMBERVALUE
- PROPER
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- SEARCH
- SEARCHB
- SUBSTITUTE
- T
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTJOIN
- TEXTSPLIT
- TRIM
- UNICHAR
- UNICODE
- UPPER
- VALUE
- VALUETOTEXT
- Web Functions
- File Operations
- Use JDK 8 Date Time API
- Document Solutions Data Viewer
- API Reference
- Release Notes
CONCAT
This function joins the text fetched from multiple strings.
Syntax
CONCAT(textvalue1, [textvalue2], ...)
Arguments
This function has the following arguments:
Argument | Description |
|---|---|
textvalue1 | [Required] Refers to a text string, or array of strings, to be joined. |
textvalue2, ... | [Optional] Additional text items to be joined. |
Remarks
There can be a maximum of 253 text items in arguments (including textvalue1 ).
In the result, this function never includes the delimiter (spaces, ampersands etc.) between each text value and never eliminates the empty arguments.
Examples
CONCAT("Riot", ", ", "Pauler") gives the result Riot Pauler