Find the latest price and lowest price out of formatted text

Hi,
I have attached the excel workbook where sheet named "Before" contains some prices in column A. I want to find out the latest price and lowest price out of those excel cells and the desired output is shown in sheet named "After". You can ignore the term "sold as special offer" as described in sheet named "Note".

When you will open the excel file then you will understand the whole problem in one glance. Many thanks for all the contributors.

Best Regards,