# Excel: How to Combine Three Columns into One

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.