Find the latest price and lowest price out of formatted text

I have the same question as Don. I settled on left most figures. Additionally I get AU $55.30 for minimum price in A4. The anticipated is AU $59.95.

In the attached column D find this for the latest figure. It's the same one I posted in post #2 and does double duty as a helper in the min formula.

Formula:

=TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(A2,CHAR(160)," ")),"Sold as a special offer ","")," ",REPT(" ",LEN(A2)),2),LEN(A2)))

Then for the minimums two helper formulas ... columns E:F ...

This cleans up and "standardizes" the strings.

Formula:

=SUBSTITUTE(TRIM(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(A2,CHAR(160)," "),"$","")),"Sold as a special offer","")),LEFT(D2,FIND(" ",D2)),"")

This one locates the last "." in the standardized helpers.

Formula:

=LOOKUP(1E+306,FIND(".",E2,ROW(INDIRECT("1:"&LEN(E2)))))

Then array enter this in G2 and filled down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

=LEFT(D2,FIND(" ",D2))&IF(ISNUMBER(FIND("$",A2)),"$","")&TEXT(MIN(--TRIM(RIGHT(SUBSTITUTE(LEFT(E2,FIND(".",E2,ROW(INDIRECT("1:"&F2)))+2)," ",REPT(" ",256)),256))),"#.00")