Concatenate Column in Excel

Objective: How to Concatenate Column Data in Excel Sheet.
EXAMPLE: Concatenate column data with comma
=CONCATENATE(A2,",")
EXAMPLE: Concatenate column data with proper digits. Here the number is concatenated with 6 digits.
=CONCATENATE("Insert into T_Tablename (Column1,Column2,Column3) values (307, '", TEXT(A2, "000000"), "',1)")
EXAMPLE: Concatenate column data of Date Format
=CONCATENATE("insert into table (startdate,EndDate) Select '",TEXT(C2,"yyyy/mm/dd"),"','",TEXT(C2,"yyyy/mm/dd"),"'")


You can see the formula in the above screen for concatenate comma.

You can see the formula in the above screen for concatenate data with certain predefined digits.

You can see the formula in the above screen to concatenate column data with Date Format.