Suppose you have those two phrases in A1 and A2. Then you can put this formula in B1 to get the first number:
Formula:
=IF(ISNUMBER(FIND("$",A1)),--MID(SUBSTITUTE(A1," ",REPT(" ",10)),FIND("$",SUBSTITUTE(A1," ",REPT(" ",10)))+1,10),"")
Copy it down column B for as many phrases that you have.
Put this formula in C1 to get the second number (if it exists):
Formula:
=IF(AND(ISNUMBER(FIND("$",A1)),LEN(A1)-LEN(SUBSTITUTE(A1,"$",""))>1),--MID(SUBSTITUTE(A1," ",REPT(" ",10)),FIND("$",SUBSTITUTE(A1," ",REPT(" ",10)),FIND("$",SUBSTITUTE(A1," ",REPT(" ",10)))+1)+1,10),"")
and again, copy down as required.
Hope this helps.
Pete
Bookmarks