Combine two or more column in excel.

Combining two or more column in an excel can simply done using the formula

=concatenate(a1,b1)





..........................................................................................................................................
 Suppose you need to add space between, use like below

=concatenate(a1," ",b1)

 

............................................................................................................................................

In between "", you can use any characters, symbols, etc..


=concatenate(a1," sachi  ",b1)

  

............................................................................................................................................

Suppose you need to concatenate more,simply use logic and do..


=concatenate(a1,b1,c1," ",d1,"/",e1)   would look like    a1b1c1 d1/e1


Hope you got it..