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:
Normally, this function is used in combining salutation, first name and last name and address data columns.
Contact us here to hear more.