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.


Download Practice Workbook

You can download the practice workbook from here.


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:

how to join two columns in excel


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

Inserting Formula to Join Two Columns in Excel

  • Next, you will get the result for the cell and then use the Fill Handle option.

  • Finally, you will get the desired result.

Read More: How to Merge Two Columns in Excel Without Losing Data


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)

Inserting Formula to Join Two Columns in Excel

  • Second, you will get the result for the cell and then use the Fill Handle option.

  • Last, you will get the desired result.

Final Result of Joining Two Columns in Excel

Read More: Merge Two Columns in Excel with First Name and Last Name


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.

Using Flash Fill to Join Two Columns in Excel

  • 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.

Using Merge Cells option to Join Two Columns in Excel

  • 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.

Copying Notepad to Join Two Columns in Excel

  • 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.

Read More: How to Merge Two Columns in Excel With a Space


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)

Inserting Formula to Join Two Rows

  • 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.

Read More: How to Merge Rows and Columns in Excel (2 Ways)


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

Henceforth, follow the above-described methods. Hopefully, these methods will help you to join two columns in excel. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our level best to solve the problem or work with your suggestions.


Related Articles

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo