Table of Contents
To combine three columns into one in Excel, you can use the CONCATENATE function or the “&” symbol to merge the data from the three columns into a new column. This will result in a single column containing the combined data from the three original columns. Alternatively, you can use the “Merge & Center” feature to merge the cells from the three columns into one cell in a new column. This method will retain the formatting of the original cells. Overall, combining three columns into one in Excel can help simplify data analysis and organization.
Excel: 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 .
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 .
Additional Resources
The following tutorials explain how to perform other common operations in Excel: