P
Pete Thurmes
Excellers,
I have an xls where there are columns of division formulas
directly entered (not containing cell references, e.g.
"=45/56" shows as what's contained in the cell when you
select it.) I'd like to break these out into separate cols
for the numerator and denominator values. I could do this
if there were a function to convert the forumula itself to
text, or some other method to deconstruct a formula.
The only way I know of is to click each cell and delete the
"=" character, then use text functions to extract the
number to the left of "/" and the number to the right.
That's a lot of work considering that I have thousands of
formulae to convert! (The labor-intensive part is deleting
the "=" from each cell)
Does anyone have any good ideas how I might accomplish this
"automagically"?
Thanks much!
--Pete
I have an xls where there are columns of division formulas
directly entered (not containing cell references, e.g.
"=45/56" shows as what's contained in the cell when you
select it.) I'd like to break these out into separate cols
for the numerator and denominator values. I could do this
if there were a function to convert the forumula itself to
text, or some other method to deconstruct a formula.
The only way I know of is to click each cell and delete the
"=" character, then use text functions to extract the
number to the left of "/" and the number to the right.
That's a lot of work considering that I have thousands of
formulae to convert! (The labor-intensive part is deleting
the "=" from each cell)
Does anyone have any good ideas how I might accomplish this
"automagically"?
Thanks much!
--Pete