Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 6th July 2009, 04:50 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default 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
Reply With Quote
  #2  
Old 7th July 2009, 01:03 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

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.
Reply With Quote
  #3  
Old 7th July 2009, 02:56 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Here is a smaller formula i got from mrexcel
=MID(A1,SEARCH("$",A1)+1,SEARCH("k)",A1)-SEARCH("$",A1)-1)
Reply With Quote
  #4  
Old 7th July 2009, 04:03 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

Thanks Shaun will try it.
Reply With Quote
  #5  
Old 7th July 2009, 06:24 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

i think that excel dude made a mistake on his formula
=MID(A1,SEARCH("$",A1)+1,SEARCH("k",A1)-SEARCH("$",A1)-1)
Reply With Quote
  #6  
Old 8th July 2009, 04:21 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

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
Reply With Quote
  #7  
Old 12th July 2009, 07:50 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 01:41 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655