Making an imported text file useful in Excel

[snd]

[TABLE="width: 932"]
<tbody>[TR]
[TD]Excel 2007
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH]_Row\^Col[/TH]
[TH]

A​

[/TH]
[TH]

B​

[/TH]
[TH]

C​

[/TH]
[TH]

D​

[/TH]
[TH]

E​

[/TH]
[TH]

F​

[/TH]
[TH]

G​

[/TH]
[TH]

H​

[/TH]
[TH]

I​

[/TH]
[TH]

J​

[/TH]
[TH]

K​

[/TH]
[TH]

L​

[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

1
​

[/TD]
[TD][/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD]

3​

[/TD]
[TD][/TD]
[TD]

GrandTotals​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

2​

[/TD]
[TD][/TD]
[TD]

Qty​

[/TD]
[TD]

Value​

[/TD]
[TD]

Qty​

[/TD]
[TD]

Value​

[/TD]
[TD]

Quantity​

[/TD]
[TD]

Value​

[/TD]
[TD]

Quantity​

[/TD]
[TD]

extend
Value​

[/TD]
[TD][/TD]
[TD]

GrandTotals​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

3​

[/TD]
[TD][/TD]
[TD]------------[/TD]
[TD]----------------[/TD]
[TD]------------[/TD]
[TD]----------------[/TD]
[TD]------------[/TD]
[TD]----------------[/TD]
[TD]------------[/TD]
[TD]----------------[/TD]
[TD][/TD]
[TD]

Quantity​

[/TD]
[TD]

extend
Value​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

4​

[/TD]
[TD]text file[/TD]
[TD]

107​

[/TD]
[TD]0 1,461.6[/TD]
[TD]2 0.0[/TD]
[TD]0 0.0[/TD]
[TD]0 0.0[/TD]
[TD]0 0.0[/TD]
[TD]0 107.0[/TD]
[TD]0 1,461.62[/TD]
[TD="bgcolor: #0F253F"][/TD]
[TD]107.0[/TD]
[TD]1,461.62[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

5​

[/TD]
[TD="bgcolor: #FFFF00"]should be[/TD]
[TD]

107​

[/TD]
[TD]

1,461.62​

[/TD]
[TD]

0.00​

[/TD]
[TD]

0.00​

[/TD]
[TD]

0.00​

[/TD]
[TD]

0.00​

[/TD]
[TD]

107​

[/TD]
[TD]

1,461.62​

[/TD]
[TD="bgcolor: #0F253F"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #0F253F"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

7​

[/TD]
[TD]text file[/TD]
[TD]T 119.0[/TD]
[TD]0 1.1[/TD]
[TD]0 0.0[/TD]
[TD]0 0.0[/TD]
[TD]0 0.0[/TD]
[TD]0 0.0[/TD]
[TD]0 119.0[/TD]
[TD]0 1.10[/TD]
[TD="bgcolor: #0F253F"][/TD]
[TD]=IFERROR(IF(ISNUMBER(H7),H7,VALUE(MID(H7,FIND(" ",H7),100))&"."&LEFT(H7,1)),"")[/TD]
[TD]=IFERROR(IF(ISNUMBER(I7),AI7,VALUE(MID(I7,FIND(" ",I7),99))),"")[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

8​

[/TD]
[TD="bgcolor: #FFFF00"]should be[/TD]
[TD]

119.00​

[/TD]
[TD]

1.10​

[/TD]
[TD]

0.00​

[/TD]
[TD]

0.00​

[/TD]
[TD]

0.00​

[/TD]
[TD]

0.00​

[/TD]
[TD]

119.00​

[/TD]
[TD]

1.10​

[/TD]
[TD="bgcolor: #0F253F"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I managed a formula for grand totals (to the best of my humble knowledge),
but it didn't work with the other cells (individual figures for qty & value).
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD]Could you please help me in constructing a good formula that will work for all
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD](grand totals and individual totals)?

[/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thank you guys for your help. You're all office life savers.

Notes: I'm using Excel-2007; hate macros & (UDFs).
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]