How to extract input values used in a formula?

guru

New member
Joined
Sep 29, 2019
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2010
A input file has a column uses formula with different values.
Example: A cell uses a formula X * Y, say =3*4 and returns 12.
Now I want to extract the input values, i.e 3 and 4, from that cell and display X and Y values in two columns.
Please help.
 
If the formula is in cell B2 then for the first number:
=VALUE(LEFT(MID(FORMULATEXT(B2),2,50),FIND("*",MID(FORMULATEXT(B2),2,50))-1))
for the second number:
=VALUE(MID(MID(FORMULATEXT(B2),2,50),FIND("*",MID(FORMULATEXT(B2),2,50))+1,20))

2019-09-30_181418.jpg
 
Last edited:
Good. Thank you. But "FORMULATEXT" fucntion is not available in Excel 2007. Is it only available in higher version or any additional module is required?
 
Back
Top