Find the latest price and lowest price out of formatted text

**FlameRetired** · 03-18-2018, 08:58 PM

In B2 this will return the latest price.

Formula:

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

The other is going to take me a while.

Are you open to helper columns?

**anonymous321** · 03-18-2018, 09:04 PM

Hi,
Thanks for the first solution.

I don't understand "helper columns".

**anonymous321** · 03-18-2018, 09:23 PM

I am just interested in the solution. You can solve this problem the way you want.

**FlameRetired** · 03-18-2018, 10:33 PM

Originally Posted by anonymous321

I don't understand "helper columns".

They are additional formulas which break down and simplify the final solution.

**anonymous321** · 03-18-2018, 10:46 PM

Its okay. You can go with most reliable and simple solution.

Re: Find the latest price and lowest price out of formatted text