How to Add Two Columns in Excel (2 Easy Methods)

add two columns in excel

Sometimes we need to combine two columns in excel to make our data more organized. This article shows 2 quick and easy ways to add two columns in excel. The following picture gives an idea about the results obtained using these 2 methods.

two columns added in excel


Download Practice Workbook

You can download the practice workbook from the download button below.


2 Quick & Easy Ways to Add Two Columns in Excel

I am going to illustrate 2 of the simplest, quickest, and easiest ways to add two columns in excel for you. We will use the following dataset to highlight the methods. Let’s start!

dataset to add two columns in excel


1. Add Two Columns in Excel Using the Ampersand Symbol (&)

Suppose, you want to add column B and column C to get the full name in column D. You can easily do that using the ampersand symbol. For that, please follow the steps below.

👉 Steps

1. At first, enter the following formula in cell D5:

=B5&C5

enter formula to add two columns

2. You can see the first name from cell B5 and the last name from cell C5 are added together as a full name in cell D5. Now apply the formula to the cells below using the fill handle tool.

use fill handle to copy formula

3. Now all the first and last names are added together in column D.

columns added in excel

4. But there is no space between the first and last names. To add a space between them, apply the simple formula given below in cell D5:

=B5&" "&C5

formula to add space between columns

5. You can see the full name in cell D5 has a space between the first and last names. Now, copy the formula down to the cells below.

Now all the full names have spaces in between the first and last names.

columns added with space in between them

Read More: How to Add Up Columns in Excel (12 Methods)


Similar Readings


2. Add Two Columns Using CONCAT Function in Excel

Another simple and easy way to add two columns in excel is to use the CONCAT function. Let’s try that by following the steps below.

👉 Steps

1. Enter the following formula in cell D5:

=CONCAT(B5,C5)

enter formula with concat function to add two columns

2. Now we see the same result obtained from the earlier method. Then copying the formula to the cells below obviously gives the same result too.

3. As there are no spaces in between the first and last names in this case also, we need to change the arguments of the function.

two columns added using the concat function

4. So, apply the following formula instead of the first one in cell D5.

=CONCAT(B5," ",C5)

formula to add space in added column

5. The following result shows that a space has been added in between the names. After that, apply the formula to the cells below.

Finally, we see similar results as obtained in the first method.

result shows two columns in excel are added together with a space in between them

Read More: How to Sum Columns in Excel When Filtered (7 Ways)


Things to Remember

  • Don’t forget to add an ampersand symbol(&) in between the cell references or texts that you want to add in the first method.
  • You must put the texts inside inverted commas(“”) in case of both of the methods.
  • The CONCAT function is the new version of the CONCATENATE function which gives the same results.
  • To add more than two columns is also possible by using either of the methods.
  • If you want to delete the first and last names then copy the full names first. Then, paste it there as values. Otherwise, you will lose all the data.

Conclusion

Now you know the 2 ways how to add two columns in excel. For further queries, please use the comment section below. If you know any other ways to add two columns in excel, please share them with us too.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo