Home Â» How to Combine Columns in Google Sheets (With Examples)

# How to Combine Columns in Google Sheets (With Examples)

You can use one of the following methods to combine multiple columns into one column in Google Sheets:

Method 1: Combine Columns with & Operator

```=A1&B1
```

Method 2: Combine Columns with & Operator and Separator in Between

```=A1&"-"&B1

=A1&" "&B1

=A1&"_"&B1
```

The following examples show how to use each method in practice.

### Method 1: Combine Columns with & Operator

Suppose we have the following dataset in Google Sheets:

We can use the following formula to combine the values in column A and column B into a new column:

`=A2&B2`

The following screenshot shows how to use this formula in practice:

Note that we can use this same formula to combine as many columns as weâ€™d like.

For example, the following formula can be used to combine the values in the Team, Conference, and Points columns:

### Method 2: Combine Columns with & Operator and Separator

We can use the following formula to combine the values in column A and column B into a new column with a space in between the values :

`=A2&" "&B2`

The following screenshot shows how to use this formula in practice:

Note that we can use any separator that weâ€™d like. For example, we could use a dash to separate the values as well: