7th July 2009, 02:03 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
|
|
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.
|