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.
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.