# TextJoin

The TextJoin functionality allows for concatenation of values in cells, with the ability to set a custom list delimiter.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2Fj805lOCEmfZyOUiXPcD5%2FGeneralProperties.png?alt=media&#x26;token=1b94da5a-90ff-48c2-bda2-489cd764496d" alt="" width="283"><figcaption></figcaption></figure>

***

## TextJoin Properties

### GENERAL

The TextJoin function contains one property section with 4 inputs, two of which require binding to the spreadsheet.

The **Series** table displays a list of existing TextJoin functionalities. Each of these are titled according to the value in the selected series' **Name** input.

The **Name** input can have data manually inserted into it, or it can be bound to a text string in a spreadsheet cell.

The **Data** input must be bound to a range of cells in the spreadsheet. Select the **Bind** button when hovering over the input, and select the range in the expanded spreadsheet. Once selected, click Confirm in the top-right.

The **Delimiter** input can have data manually inserted into it, or it can be bound to a value in a spreadsheet cell. The nature of this input means that the delimeter can be something more than just a comma, or quotation marks.

The **IgnoreBlank** check mark will read through a bound range and ignore all blank cells that exist in that range.

The **Output** input is the cell in the spreadsheet where you would like our delimited list to display. This must be bound to the spreadsheet.&#x20;

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FjPMipO3aj18fYxINzW4z%2FTextJoin.png?alt=media&#x26;token=a8a5ff6c-017b-4e46-aa84-f77916d9c56e" alt=""><figcaption><p>Oh, my!</p></figcaption></figure>
