I run a for each row on the datatable (say Dt) and then assign the new columns as -. new DataColumn = Dt. Columns .Add ("Old Date", GetType (String), a) and similarly for the other columns using variables b,c and d. I am then writing the data table into an excel. While doing that, the output column > header comes as "Old Date + (the last date. Select the cells that contain the data or other attributes that you want to copy. On the Home tab, click Copy . Click the first cell in the area where you want to paste what you copied. On the Home tab, click the arrow next to Paste, and then do any of the following. The options on the Paste menu will depend on the type of data in the selected.