Extract Values from Formulas

  • Thread starter Thread starter sachinattri
  • Start date Start date
S

sachinattri

Hi there,

I have a set of manually entered values, example of one is

*=sum(200+150)* OR *+200+150*

The result is 350. but what I want to do is Extract the Second Set of
Values from this.

The end result I want is "150" in a separate cell.

If it cant be done for second set we can try the first set in which
case the result would be "200".

Thank you
 
Hi,
I think it is better for you to introduce data in separate cells an
then work on any formula you want .

Rgds
 
Yes I know. the problem is I received this data from somewhere and
want to extract otherwise I would have to type in values manually fo
approx. 2000 rows. Thank
 
Hi Sach,

If you want , i can give you the help i got for the same matter from a
Genius !
first you need to get this add in for excel
http://longre.free.fr/english/index.html

and then see the below :

"
Entered in B1 and copied across:

=WMID(SUBSTITUTE(FORMULATEXT($A1),"=","",1),COLUMN()-COLUMN($B$1)+1,1,"+")


where A1 =200+150 "

Good luck !
 
Back
Top