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 |
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) |
Quote:
|
Quote:
|
All times are GMT +10. The time now is 07:24 PM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.