unique left/right or mid formulas needed

[Wimpie]

Good day

Please see the blow, al in A2 and A3
[TABLE="class: grid, width: 1000"]
<tbody>[TR]
[TD]18 Jul Rtc Credit Eco Smart 0672564266 8,000.00 Cr 10,886.96 Cr
[/TD]
[/TR]
[TR]
[TD]18 Jul FNB App Payment To Shipping - Nancy Usa Sarah Cronin Designs 7,425.80 3,461.16 Cr 3.75
[/TD]
[/TR]
</tbody>[/TABLE]

I need 2 fomulas
1 - i need to extract the 1st mount in one column eg.R8000.00 in A2 & 7,425.80 in A3
2 - all the text before the amounts above to start from the date (Jul) to theamount mentioned above in a seprate column

Any help will be greatly appreciated.

[TABLE="width: 48"]
<colgroup><col width="64" style="width: 48pt;"><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Wimpie]

I have also found one that looks different from the above examples
19 Jul Chq Card Fuel Purchase Afrox 006 Bramley 457896*5700 18 Jul 614.20 1,852.91 Cr

The amout here is 614.20 and I need all the text from 19 jul till before the amount of 614.20

 

[Wimpie]

Hi
I managed to get the amount with some helper columns