Pull Text Value from Cell String

[exc4libur]

Hi guys,

I have a set of data in column A that goes like this:

[A1] Market: Cheetos & Coke | Supermarket X | $ 3.65 [=2.65+1] (Visa)
[A2] Lunch: Chicken (200 g) & Salad | Garden Grill | $ 21 (MasterCard)

I want to extract the numeric value after the money sign from each string "$".

So, what I am supposed to get in Column B is,

[B1] Answer = 3.65
[B2] Answer = 21

Any help would be awesome!
Thanks in advance,
Exc4.

 

[John Jairo V]

Hi @exc4libur

I made a name formula "a" (press Ctrl + F3 - Name Manager) with this formula:
=2+FIND("$",A1)

And use this formula (B1):
=MID(A1,a,FIND(" ",A1,a)-a)

Or, if you want to do it without name Manager, you can use this (B1):
=MID(A1,2+FIND("$",A1),FIND(" ",A1,2+FIND("$",A1))-2-FIND("$",A1))

Blessings!

 

[exc4libur]

GENIUS!!!!!!!!!!!!! :D

Thank you