OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)

- - Excel help (http://forums.ozmium.com.au/showthread.php?t=19047)

Crackone

6th July 2009 05:50 PM

Excel help

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

7th July 2009 02:03 PM

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

7th July 2009 03:56 PM

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

Crackone

7th July 2009 05:03 PM

Thanks Shaun will try it.

Shaun

7th July 2009 07:24 PM

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

Crackone

8th July 2009 05:21 PM

Quote:

Originally Posted by Shaun

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

12th July 2009 08:50 PM

Quote:

Originally Posted by Shaun

Here is a smaller formula i got from mrexcel

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

All times are GMT +10. The time now is 09:48 AM.