Extracting a value from a formula

[GB]

Hi,

I have been given a spreadsheet that contains a formula like so...

Cell B1 contains =A1*3.89

Cell B2 contains =A2*10.67

etc


What I want to do is extract each constant value in column B from each formula and place it in column C. How can this be achieved?


Thanks in advance

GB

 

[mercatog]

Hi

I'll be with a little stupide idea if all formula in Bxx

=Axx*Constant and Axx<>0 then the constant in Cxx =Bxx/Axx

Regards

 

[Hui]

Following on from Mercatog's comment

Then copy Column C and paste as Values over itself

 

[YD]

use text to colum & delimit it by using "*" cheers

Thanks YD

 

[shrivallabha]

Here's a blast from the past Excel4Macro function:

http://www.youtube.com/watch?v=TpV__z0iZmo

 

[GB]

Thanks Mercatog and the rest of you for contributing to the answer. It was so simple, I feel dumb for asking now. That's was happens when you come back from a long holiday, you brain goes numb.


cheers

GB

 

[GeorgeF211]

Any admin about to deal with the bags95760 post?