How to concatenate (Combine) multiple columns into one field in MS Excel

 In MS Excel, We have multiple columns data where we want to combine all these columns data to a single column.

There is a two way  to do that .

Example-1:

Create a new column and give and concat all the data 

Use the CONCATENATE function in that new column. 

=CONCATENATE(A2,B2,C2).

Example-2

=concatenate A1&B1&C1 and press Enter

if you want add some special character between the columns data such as (space,comma,dash, etc ), You can use the below formula .

=CONCATENATE(A1&" ," &B1&", " & C1&","&D1&"," &E1&"," &F1&","&G1)