Adding header row to Excel files

yatt0618

New Member
Joined
Jul 8, 2018
Messages
1
Hi Girls and Boys,


Will be greatly appreciate if someone could give me some insight on whether this is something can be done.


I got a lot of excel/txt file that need to add one line of coluum on top. Here is what I really meant:


From:


"Loading,1.024,0.3725408,0.01414836,0, , ,0.3725408,0.05317445,0, , , , , , , , ,0.003700595,0, , , , ,0,0, , , , , "
"Loading,2.304,1.039208,0.04485469,0, , ,1.039208,0.08378078,0, , , , , , , , ,0.02530482,0, , , , ,0,0, , , , , "
"Loading,3.584,2.147026,0.08137956,0, , ,2.147026,0.1201395,0, , , , , , , , ,0.08322852,0, , , , ,0,0, , , , , "




Into
"TD;50mN_v3.000;0;0.03908197;0;0.2103292;0.0575648;0:0:0;21/05/18:11:31:02;True;0.00015;; ;2;0;0;82.53362;Poly2/80%;1;,t (sec),P (raw),ht (raw),S,Lateral Force (mN),Lateral Distance (um),P (mN),ht (um),ADC 1/0,hc,a,dP/dh,E*(GPa),H (GPa),Position(um),Friction,E (GPa),Up (nJ),Ue (nJ),E1,E2,n1,n2,AE/C,AE/S,h corr,HV,HM,-,-"
"IC,0,0.1503822,-6.101884E-05,0, , ,0.1503822,0.03902095,0, , , , , , ,, ,0,0, , , , ,0,0, , , , , "
"Loading,1.024,0.3725408,0.01414836,0, , ,0.3725408,0.05317445,0, , , , , , , , ,0.003700595,0, , , , ,0,0, , , , , "
"Loading,2.304,1.039208,0.04485469,0, , ,1.039208,0.08378078,0, , , , , , , , ,0.02530482,0, , , , ,0,0, , , , , "
"Loading,3.584,2.147026,0.08137956,0, , ,2.147026,0.1201395,0, , , , , , , , ,0.08322852,0, , , , ,0,0, , , , , "
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,109,532
Messages
5,529,393
Members
409,870
Latest member
Well59
Top