How to extract text before & after a space from the right?

I have the following text in a cell:

Cell A1: PP TO JOHN F MADIGAN 300.00 17,550.72
Cell A2: PP TO J & K MADIGAN 3,400.00 4,150.72
Cell A3: PP TO K L & D C MADIGAN 21,350.00 1,621.21

I want a formula to extract the above into these
Cell B1: 300.00
Cell B2: 3,400.00
Cell B3: 21,350.00

Cheers.

If you want it literally returned exactly as it appears as a text string..
Try
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1)*LEN(A1),LEN(A1)))

If you want that returned as an actual numeric value (3400 instead of 3,400.00)
=MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1)*LEN(A1),LEN(A1))+0
You can then use cell formatting to show the decimals.