Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

# How to Join Two Columns in Excel (5 Easy Methods)

This tutorial will demonstrate how to join two columns in excel. When dealing with lots of data, sometimes we need to join two columns in excel to avoid confusion. Joining two columns helps us in merging dates or full names or subject names etc. So, it is very important to learn how to join two columns in excel.

## 5 Easy Methods to Join Two Columns in Excel

We’ll use a sample dataset overview as an example in Excel to understand easily. In this case, we have the First Column in column B, Second Column in column C, and Combined Columns in column D. If you follow the steps correctly, you should learn how to join two columns in excel on your own. The methods are: ### 1. Use of Ampersand Operator

In this case, our goal is to join two columns in an excel file by using the Ampersand Operator. It is actually used to join texts without using any function. This operator is very easy to use and modify. The steps of this method are.

Steps:

• First, insert the following formula in cell D5.
`=B5&" "&C5` • Next, you will get the result for the cell and then use the Fill Handle option. • Finally, you will get the desired result. ### 2. Applying CONCAT Function

Now, we aim to join two columns in excel by applying the CONCAT function. When you need to merge two or multiple cells, it is the most useful function. The function is widely used for its larger range of connecting cells. The steps of this method are.

Steps:

• At first, insert the following formula in cell D5.
`=CONCAT(B5," ",C5)` • Second, you will get the result for the cell and then use the Fill Handle option. • Last, you will get the desired result. ### 3. Utilizing Flash Fill

We can use the Flash Fill option to join two columns in excel. This method is only useful when both columns contain texts. The steps of this method are.

Steps:

• To begin with, write the full combined text of the cells in cell D5. • In addition, again write another combined full text in cell D6. Then, you will see excel showing the combined text for all the cells. • Finally, press the Enter button to get the desired result. Read More: How to Merge Columns in Excel (4 Ways)

### 4. Using Merge Cells Option

This time, our goal is to join columns by using the Merge Cells option. The steps of this method are.

Steps:

• Firstly, arrange the desired dataset. • Secondly, select the cells you want to merge.
• Then go to Home > Merge & Center options. • Thirdly, press OK to get the result. • Fourthly, you will get results for the cell. • Lastly, you will get the desired result if you repeat the steps for the whole table. ### 5. Joining Columns Via Notepad

If any of the above methods are not available to you, then you can use Notepad to join the columns. The steps of this method are.

Steps:

• To begin with, select the desired data portion and copy it using the Ctrl+C buttons. • In addition, open the notepad and paste the copied data here. • Furthermore, press the Tab button on the keyboard at the end of the data and select the space portion, and copy it using the Ctrl+C buttons. • After that, press the Ctrl+H options to open the Replace dialog box and select Replace All option here. • Next, you will get the below result and copy it using the Ctrl+C buttons. • Finally, paste the data into the excel worksheet and rename the column heading as Combined Columns. Thus. you will get the desired result. ## How to Merge Two Rows in Excel

In this case, our goal is to merge two rows in excel by following the below steps.

Steps:

• First, arrange the dataset. • Second, insert the following formula in cell D5.
`=CONCAT(B5," ",B6)` • Third, you will get the result for the cell. • Last, if you do the same for any two rows again, you will get the same result. ## Things to Remember

• The first method is the easiest among all methods if you want to combine two columns only.
• If you want to merge multiple columns, then you have to use the second method.
• In any case, if your columns only have text functions then you can use the third method. Normally, if you have numbers or any other data than text, then this method should not be used.
• The fourth method will only show the data of the upper left portion if you merge them.

## Conclusion  