How to merge two columns in excel without losing data

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

Method 1: Use CONCAT Function

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

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:

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 d

how to merge three columns in excel with text

how to combine three columns in excel