Extract price from text string

[tigerme]

Hi. Please help, I need to extract the price from a text string - they've taken out the currency symbol so it's just the number format #.##

For example

'Spiderman: Web Of Shadows - Amazing Allies Edition (Sony PSP) Game Spanish Box';angelicxrose6_3 Final price: 8.95 (Buy it now).

To return a value of 8.95

or

to return a value of 27.56

it's always before an open bracket (

Thanks in advance!

 

[etaf]

is it always following price:

how about
=MID(A2,SEARCH("price:",A2,1)+6,MATCH(2,1/(MID(A2,SEQUENCE(LEN(A2)),1)="("))-(SEARCH("price:",A2,1)+6))*1

Book2
	A	B	C	D
1
2	((( Price: 213.56 ( )			213.56
3	Spiderman: Web Of Shadows - Amazing Allies Edition (Sony PSP) Game Spanish Box';angelicxrose6_3 Final price: 8.95 (Buy it now).			8.95
4
5
Sheet1

Cell Formulas
Range	Formula
D2:D3	D2	=MID(A2,SEARCH("price:",A2,1)+6,MATCH(2,1/(MID(A2,SEQUENCE(LEN(A2)),1)="("))-(SEARCH("price:",A2,1)+6))*1

 

[Domenic]

Assuming that it always follows "price" and precedes the opening bracket, here are a couple of other possibilities . . .

=TRIM(LEFT(MID(A1,FIND("price:",A1)+6,LEN(A1)),FIND("(",MID(A1,FIND("price:",A1)+6,LEN(A1)))-1))

or

=LET(s,TRIM(MID(A1,FIND("price:",A1)+6,LEN(A1))),TRIM(LEFT(s,FIND("(",s)-1)))

 

[Fluff]

For Windows only
If it's always the last number, another option

=FILTERXML("<k><m>"&SUBSTITUTE(A2," ","</m><m>")&"</m></k>","//m[.=number()][last()]")

Alternatively, if it's always preceded by "price"

=FILTERXML("<k><m>"&SUBSTITUTE(A2," ","</m><m>")&"</m></k>","//m[.='price:']/following::m[1]")

 

[JEC]

How about

=TRIM(MID(A1,SEARCH("?.??",A1)-1,5))

 

[alansidman]

Another option available is with Power Query/Get and Transform Data found on the Data Tab

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Extracted Text Between Delimiters" = Table.TransformColumns(Source, {{"Column1", each Text.BetweenDelimiters(_, ":", "(", {0, RelativePosition.FromEnd}, 0), type text}})
in
    #"Extracted Text Between Delimiters"

 

[Sufiyan97]

Try

=TRIM(LEFT(MID(A1,SEARCH("Price:",A1)+7,99),SEARCH("(",MID(A1,SEARCH("Price:",A1)+7,99))-1))+0

 

[Peter_SSs]

A variation on @Domenic's theme
=LET(s,REPLACE(A1,1,FIND("price:",A1)+5,""),LEFT(s,FIND(" (",s))+0)

 

[Phuoc]

One way:

=AGGREGATE(14,6,--MID(A1,SEARCH("Price:",A1)+7,SEQUENCE(LEN(A1))),1)

=LOOKUP(10^35,--MID(A1,SEARCH("Price:",A1)+7,SEQUENCE(LEN(A1))))

 

[tigerme]

Thank you everyone, that has done the trick! Each of them have worked which has given me food for thought but #8 was the quick and simple solution!