---
title: "Use The & Function To Concatenate Multiple Text Values"
slug: "ampersand-function"
description: "Learn to simplify text operations in Pigment by using the & function to join strings across your datasets."
updated: 2025-05-30T09:42:29Z
published: 2025-08-22T10:57:28Z
canonical: "kb.pigment.com/ampersand-function"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# & function

## Description

Concatenates all the given text arguments.

## Syntax

```plaintext
text1 & text2 & ...
```

- Each argument should have text type, using TEXT if needed
- If Metrics are used, they should be at least on the Dimensions of the target Metric

## Return type

`Text`

## Examples

| **Case** | **Results** | **Return Type** |
| --- | --- | --- |
| `"abc" & " - " & "123"` | `"abc - 123"` | `Text` |
| Building a new list Property from existing ones: `Country.Name & "(" & Country.Region & ")"` | `"France (Europe)"` | `Text` |

**Excel equivalent**: [CONCAT(text1, [text2], ...)](https://support.microsoft.com/en-us/office/concat-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2)

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style><style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>