> For the complete documentation index, see [llms.txt](https://learn.squirrel365.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.squirrel365.io/components-functions-and-connections/overview-1/spreadsheet-and-data/textjoin.md).
# TextJoin
The TextJoin functionality allows for concatenation of values in cells, with the ability to set a custom list delimiter.
***
## 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.