# CONCAT

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function joins the text fetched from multiple strings.

## Syntax

CONCAT(*textvalue1, textvalue2,...*)

## Arguments

This function has the following arguments:

| **Arguments** |  |
| --------- | --- |
| *textvalue1* | Refers to a text string, or array of strings, to be joined. |
| *textvalue2* | [Optional] Refers to the additional text strings 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.

## Data Types

Accepts string data. Returns string data.

## Examples

`CONCAT(Riot,",",Pauler)` gives the result Riot Pauler.

## Version Available

This function is available in Spread for Windows Forms 11.0 or later.