How to Combine Columns in Google Sheets (With Examples)

by Tutor Aspire January 17, 2023

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.

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:

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:

The following tutorials explain how to perform other common operations in Google Sheets: