> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Concat

> Use the Sigma Concat function to combine one or more text strings into a single string.

The **Concat** function combines one or more text strings into a single string.

## Syntax

```
Concat(string_1, string_2, ...)
```

Function arguments:

|                |                                                           |
| :------------- | :-------------------------------------------------------- |
| **string\_1**  | (required) First string to combine in the sequence.       |
| **string\_2+** | (optional) Additional strings to combine in the sequence. |

## Notes

* **Concat** doesn't automatically add spaces between strings. To add a space in the output, include `" "` as its own argument.
* To concatenate a value of another data type with text data, convert the values to text using quotation marks or the **[Text](/docs/text)** function.
  * To concatenate a date value with a string, place quotation marks around the date value, such as `"2024-01-01"`.
  * To convert values from a column of another data type to text, use the **[Text](/docs/text)** function, such as `Text([ID Number])`.
* Optionally, use the `&` operator to concatenate multiple text values for concision. For example, `Concat([First Name], " ", [Last Name])` is equivalent to `[First Name] & " " & [Last Name]`.

## Examples

```
Concat("queen", "bee")
```

Returns `queenbee`.

```
Concat("queen", " ", "bee")
```

Returns `queen bee`.

```
Concat([Name], Text([ID No]))
```

Combines a column of names with their corresponding ID numbers. For example, if the *Name* column contains `John` and the *ID No* column contains `123`, the output is `John123`.

```
Concat([Store Region], "\n", [Store State])
```

When the newline character (`\n`) is added as an argument, the subsequent argument is displayed on a new line. To view the output on separate lines in Sigma, select **More options** <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/ellipsis-horizontal.svg" alt="" /> > **Wrap text** <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/text-wrap.svg" alt="" />.

![A table shows the output of the formula Concat(\[Store Region\], "\n", \[Store State\]). A user hovers over wrap text to demonstrate that the output is on separate lines](/home/runner/work/sigma-docs/sigma-docs/fern/assets/docs-images/3153d231d13ae665d35a713e53745b05ca0f5e8b9bf524b1884a219a145e626c-update_concat_screenshot.png)

## Related resources

* [ListAgg](/docs/listagg)