Making an imported text file useful in Excel

[snd]

Excel 2007 Row\Col A​ B​ C​ D​ E​ F​ G​ H​ I​ J​ K​ L​ 1 ​ 1​ 2​ 3​ GrandTotals​ 2​ Qty​ Value​ Qty​ Value​ Quantity​ Value​ Quantity​ extend Value​ GrandTotals​ 3​ ------------ ---------------- ------------ ---------------- ------------ ---------------- ------------ ---------------- Quantity​ extend Value​ 4​ text file 107​ 0 1,461.6 2 0.0 0 0.0 0 0.0 0 0.0 0 107.0 0 1,461.62 107.0 1,461.62 5​ should be 107​ 1,461.62​ 0.00​ 0.00​ 0.00​ 0.00​ 107​ 1,461.62​ 6​ 7​ text file T 119.0 0 1.1 0 0.0 0 0.0 0 0.0 0 0.0 0 119.0 0 1.10 =IFERROR(IF(ISNUMBER(H7),H7,VALUE(MID(H7,FIND(" ",H7),100))&"."&LEFT(H7,1)),"") =IFERROR(IF(ISNUMBER(I7),AI7,VALUE(MID(I7,FIND(" ",I7),99))),"") 8​ should be 119.00​ 1.10​ 0.00​ 0.00​ 0.00​ 0.00​ 119.00​ 1.10​ <tbody> </tbody> Sheet: Sheet1 <tbody> </tbody>
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).
Could you please help me in constructing a good formula that will work for all
(grand totals and individual totals)?
Thank you guys for your help. You're all office life savers. Notes: I'm using Excel-2007; hate macros & (UDFs).

<tbody>
</tbody>