Excel

How to Combine Two Columns in Excel

How to Combine Two Columns in Excel

There are a few ways to combine two columns in Excel. One way is to use the CONCATENATE function. The CONCATENATE function takes two or more strings of text and combines them into one string. The syntax for the CONCATENATE function is:

=CONCATENATE(text1,text2,text3,...)

To combine two columns in Excel, you can use the following formula:

=CONCATENATE(A1,B1)

This will combine the values in the A1 and B1 cells into one string.

Another way to combine two columns in Excel is to use the & operator. The & operator concatenates two strings of text and returns a string. The syntax for the & operator is:

=text1&text2

To combine two columns in Excel, you can use the following formula:

=A1&B1

This will combine the values in the A1 and B1 cells into one string.

The third way to combine two columns in Excel is to use the VLOOKUP function. The VLOOKUP function takes two or more strings of text and compares them. The function then returns the value from the first string that is found in the second string. The syntax for the VLOOKUP function is:

=VLOOKUP(text1,table_array,col_index_num,range_lookup)

To combine two columns in Excel, you can use the following formula:

=VLOOKUP(A1,A2:B10,2,FALSE)

This will combine the values in the A1 and B1 cells into one string.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.