Articles > Blogs, Tips and Tricks > How to integrate or combine values from two (2) or more columns in Excel?

How to integrate or combine values from two (2) or more columns in Excel?

The function of Microsoft Excel that can do this is called Concatenate Function.   The below image shows how  Concatenate Function works:

There are cases where there is a need to combine two or more different data contained in different columns.  In the example above, Column A contains Customer No. and Column B contains Invoice No.    To combine or concatenate these two (2) different data contained in two (2) different columns, the below formula should be entered in the cell with address C2:

=Concatenate(A2,B2)

Normally, this function is used in combining salutation, first name and last name and address data columns.  

Contact us here to hear more.