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

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.

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

Thanks Shaun will try it.

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

Thanks for the site to Shaun joined up, how good are they.