Crackone

6th July 2009, 04:50 PM

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

Parmenter Jiear Builders (65) ($14.000k)

Cheers

View Full Version : Excel help

Crackone

6th July 2009, 04:50 PM

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

Parmenter Jiear Builders (65) ($14.000k)

Cheers

Shaun

7th July 2009, 01: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.

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, 02:56 PM

Here is a smaller formula i got from mrexcel

=MID(A1,SEARCH("$",A1)+1,SEARCH("k)",A1)-SEARCH("$",A1)-1)

=MID(A1,SEARCH("$",A1)+1,SEARCH("k)",A1)-SEARCH("$",A1)-1)

Crackone

7th July 2009, 04:03 PM

Thanks Shaun will try it.

Shaun

7th July 2009, 06:24 PM

i think that excel dude made a mistake on his formula

=MID(A1,SEARCH("$",A1)+1,SEARCH("k",A1)-SEARCH("$",A1)-1)

=MID(A1,SEARCH("$",A1)+1,SEARCH("k",A1)-SEARCH("$",A1)-1)

Crackone

8th July 2009, 04:21 PM

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

=MID(A1,SEARCH("$",A1)+1,SEARCH("k",A1)-SEARCH("$",A1)-1)No it work fine for me

Crackone

12th July 2009, 07:50 PM

Here is a smaller formula i got from mrexcel

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

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

vBulletin v3.0.3, Copyright ©2000-2024, Jelsoft Enterprises Ltd.