There are two common methods you can use to combine three columns into one in Excel:

**Method 1: Use CONCAT Function**

**=CONCAT(A2:C2)**

This particular formula will combine the values from cells **A2**, **B2** and **C2** into one cell with no spaces between the values.

**Method 2: Use TEXTJOIN Function**

=TEXTJOIN(" ", TRUE, A2:C2)

This particular formula will combine the values from cells **A2**, **B2** and **C2** into one cell with spaces between the values.

The following examples show how to use each formula in practice with the following dataset in Excel that contains information about total sales made by employees at some company:

Let’s jump in!

**Example 1: Combine Three Columns into One Using CONCAT**

We can type the following formula into cell **D2** to combine the values in cells **A2**, **B2** and **C2** with no space between the values:

**=CONCAT(A2:C2)**

We can then click and drag this formula down to each remaining cell in column D:

Column D combines the values from columns A, B and C into a single cell with no space in between the values.

**Note**: You can find the complete documentation for the **CONCAT** function in Excel here.

**Example 2: Combine Three Columns into One Using TEXTJOIN**

We can type the following formula into cell **D2** to combine the values in cells **A2**, **B2** and **C2** with a space between the values:

=TEXTJOIN(" ", TRUE, A2:C2)

We can then click and drag this formula down to each remaining cell in column D:

Column D combines the values from columns A, B and C into a single cell with a space in between the values.

Note that the first argument of the **TEXTJOIN** function specifies the delimiter to use when joining the values together.

We could use the following formula, for example, to combine the values from columns A, B and C with a dash in between the values:

=TEXTJOIN("-", TRUE, A2:C2)

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

Column D now combines the values from columns A, B and C into a single cell with a dash in between the values.

**Note**: You can find the complete documentation for the **TEXTJOIN **function in Excel here.

**Additional Resources**

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

How to Concatenate Text & Date in Excel

How to Use a Concatenate If Formula in Excel

How to Combine Two Columns with Space in Excel