Excel help

[Crackone]

Hi was after a formula that would extract the 14000 value out of the following, tried MAX no good

Parmenter Jiear Builders (65) ($14.000k)

Cheers

[Shaun]

Cell A1 has Jiear Builders (65) ($14.000k)
Cell A2 =LEFT(RIGHT(RIGHT(A1,FIND("(",A1)-1),FIND("$",RIGHT(A1,FIND("(",A1)-1))+1),FIND("k",RIGHT(RIGHT(A1,FIND("(",A1)-1),FIND("$",RIGHT(A1,FIND("(",A1)-1))+1))-1)

Some one miht be able to shorten the code for you.

[Shaun]

Here is a smaller formula i got from mrexcel
=MID(A1,SEARCH("$",A1)+1,SEARCH("k)",A1)-SEARCH("$",A1)-1)

[Crackone]

Thanks Shaun will try it.

[Shaun]

i think that excel dude made a mistake on his formula
=MID(A1,SEARCH("$",A1)+1,SEARCH("k",A1)-SEARCH("$",A1)-1)

[Crackone]

i think that excel dude made a mistake on his formula
=MID(A1,SEARCH("$",A1)+1,SEARCH("k",A1)-SEARCH("$",A1)-1)No it work fine for me

[Crackone]

Here is a smaller formula i got from mrexcel
Thanks for the site to Shaun joined up, how good are they.