unique left/right or mid formulas needed

[Wimpie]

Good day

Please see the blow, al in A2 and A3

18 Jul Rtc Credit Eco Smart 0672564266 8,000.00 Cr 10,886.96 Cr

18 Jul FNB App Payment To Shipping - Nancy Usa Sarah Cronin Designs 7,425.80 3,461.16 Cr 3.75

<tbody>
</tbody>

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.

<colgroup><col width="64" style="width: 48pt;"><tbody>
</tbody>

 

[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