format data

[dantheman9]

How can i modify a file from this;

[RANGE=cls:xl2bb-100][XR][XH=cs:7]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]A[/XH][XH]B[/XH][XH]C[/XH][XH]D[/XH][XH]E[/XH][XH]F[/XH][/XR][XR][XH]1[/XH][XD=h:l]Interval[/XD][XD=h:l]Boat[/XD][XD=h:l]Time[/XD][XD=h:l]Meters[/XD][XD=h:l]Split_Avg_Pace[/XD][XD=h:l]Split_Stroke_Rate[/XD][/XR][XR][XH]2[/XH][XD][/XD][XD=h:l]M Andrews (Central)[/XD][XD=h:r]02:00.0[/XD][XD=h:r]449[/XD][XD=h:r]02:13.6[/XD][XD=h:r]26[/XD][/XR][XR][XH]3[/XH][XD][/XD][XD][/XD][XD=h:r]04:00.0[/XD][XD=h:r]427[/XD][XD=h:r]02:20.5[/XD][XD=h:r]26[/XD][/XR][XR][XH]4[/XH][XD][/XD][XD=h:l]S Barrie (Central)[/XD][XD=h:r]02:00.0[/XD][XD=h:r]423[/XD][XD=h:r]02:21.8[/XD][XD=h:r]29[/XD][/XR][XR][XH]5[/XH][XD][/XD][XD][/XD][XD=h:r]04:00.0[/XD][XD=h:r]394[/XD][XD=h:r]02:32.3[/XD][XD=h:r]29[/XD][/XR][XR][XH]6[/XH][XD][/XD][XD=h:l]E Bayton (Ripley)[/XD][XD=h:r]02:00.0[/XD][XD=h:r]449[/XD][XD=h:r]02:13.6[/XD][XD=h:r]35[/XD][/XR][XR][XH]7[/XH][XD][/XD][XD][/XD][XD=h:r]04:00.0[/XD][XD=h:r]448[/XD][XD=h:r]02:13.9[/XD][XD=h:r]38[/XD][/XR][XR][XH]8[/XH][XD][/XD][XD=h:l]E Peill (Ripley)[/XD][XD=h:r]02:00.0[/XD][XD=h:r]445[/XD][XD=h:r]02:14.8[/XD][XD=h:r]32[/XD][/XR][XR][XH]9[/XH][XD][/XD][XD][/XD][XD=h:r]04:00.0[/XD][XD=h:r]464[/XD][XD=h:r]02:09.3[/XD][XD=h:r]34[/XD][/XR][XR][XH]10[/XH][XD][/XD][XD=h:l]J Pearson (Ripley)[/XD][XD=h:r]02:00.0[/XD][XD=h:r]477[/XD][XD=h:r]02:05.8[/XD][XD=h:r]27[/XD][/XR][XR][XH]11[/XH][XD][/XD][XD][/XD][XD=h:r]04:00.0[/XD][XD=h:r]474[/XD][XD=h:r]02:06.6[/XD][XD=h:r]28[/XD][/XR][XR][XH=cs:7][RANGE][XR][XD]SPLIT[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE][B]Excel 2007[/B]

to this;

[RANGE=cls:xl2bb-100][XR][XH=cs:5]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]A[/XH][XH]B[/XH][XH]C[/XH][XH]D[/XH][/XR][XR][XH]1[/XH][XD=h:l]Name[/XD][XD=h:l]Split 02:00:00[/XD][XD=h:l]Split 00:04:00[/XD][XD=h:l]Finish[/XD][/XR][XR][XH]2[/XH][XD=h:c]M Andrews (Central)[/XD][XD=h:r]449[/XD][XD=h:r]427[/XD][XD=h:r]876[/XD][/XR][XR][XH]3[/XH][XD][/XD][XD=h:r]26[/XD][XD=h:r]26[/XD][XD=h:r]26[/XD][/XR][XR][XH]4[/XH][XD=h:c]S Barrie (Central)[/XD][XD=h:r]423[/XD][XD=h:r]394[/XD][XD=h:r]817[/XD][/XR][XR][XH]5[/XH][XD][/XD][XD=h:r]29[/XD][XD=h:r]29[/XD][XD=h:r]29[/XD][/XR][XR][XH]6[/XH][XD=h:c]E Bayton (Ripley)[/XD][XD=h:r]449[/XD][XD=h:r]448[/XD][XD=h:r]897[/XD][/XR][XR][XH]7[/XH][XD][/XD][XD=h:r]35[/XD][XD=h:r]38[/XD][XD=h:r]36.5[/XD][/XR][XR][XH]8[/XH][XD=h:c]E Peill (Ripley)[/XD][XD=h:r]445[/XD][XD=h:r]464[/XD][XD=h:r]909[/XD][/XR][XR][XH]9[/XH][XD][/XD][XD=h:r]32[/XD][XD=h:r]34[/XD][XD=h:r]33[/XD][/XR][XR][XH]10[/XH][XD=h:c]J Pearson (Ripley)[/XD][XD=h:r]477[/XD][XD=h:r]474[/XD][XD=h:r]951[/XD][/XR][XR][XH]11[/XH][XD][/XD][XD=h:r]27[/XD][XD=h:r]28[/XD][XD=h:r]27.5[/XD][/XR][XR][XH=cs:5][RANGE][XR][XD]Sheet3[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE][B]Excel 2007[/B][RANGE=cls:xl2bb-extra-100][XR][XH=cs:2]Cell Formulas[/XH][/XR][XR][XD]Cell[/XD][XD]Formula[/XD][/XR][XR][XD]D2[/XD][XD]=SUM(B2:C2)[/XD][/XR][XR][XD]D3[/XD][XD]=AVERAGE(B3,C3)[/XD][/XR][XR][XD]D4[/XD][XD]=SUM(B4:C4)[/XD][/XR][XR][XD]D5[/XD][XD]=AVERAGE(B5,C5)[/XD][/XR][XR][XD]D6[/XD][XD]=SUM(B6:C6)[/XD][/XR][XR][XD]D7[/XD][XD]=AVERAGE(B7,C7)[/XD][/XR][XR][XD]D8[/XD][XD]=SUM(B8:C8)[/XD][/XR][XR][XD]D9[/XD][XD]=AVERAGE(B9,C9)[/XD][/XR][XR][XD]D10[/XD][XD]=SUM(B10:C10)[/XD][/XR][XR][XD]D11[/XD][XD]=AVERAGE(B11,C11)[/XD][/XR][/RANGE]

I could have up to 40 names to convert, and the splits may change from time to distance (so would need to be able to swap between the too).
Split intervals can range from 2 up to 10 points.

thanks in adanvce for any help on this!