importing a text file

[kenparker23]

I need to import a text file. Here is an example of the text file.

1 Gilbert Ridge @ PinewoodO 17-17
1 Lyles @ Fernvale 10-14
1 Pinewood @ Vaughn's Gap 10-14
1 Theta @ Turnbull 3-40
1 Wrigley @ Bowieland 34-17
1 Bon Aqua @ Brush Creek 33-16


Here is what I need to get it to look like on the excel sheet


Column G Column H
Week 1
Gilbert Ridge 17
Pinewood 17
Lyles 10
Fernvale 14

I could not get the html maker to work. The numbers are in column H and the text is in coulmn G. I have tried all of the text import options and can't get it formated like this

Thanks again[/code]

 

[kenparker23]

here is an example of how I would like it to be formatted on the sheet

Book2
	A	B	C	D
1	Gilbert Ridge	17
2	PinewoodO	17
3	Lyles	10
4	Fernvale	14
5	Pinewood	10
6	Vaughns Gap	14
7	Theta	3
8	Turnbull	40
9	Wrigley	34
10	Bowieland	17
11	Bon Aqua	33
12	Brush Creek	16
Sheet1