find - Return a part of a fraction in Calc Openoffice. -

find - Return a part of a fraction in Calc Openoffice. -

what have calc openoffice homecoming value of denominator of cell. right or left, i'm constrained position.

is there way me find denominator of cell irrespective of amount of digits in cell?

so have 3 cells, a1, b1, c1. values 1/3; 13/4; 1/1003, respectively want calc homecoming 3; 4; 1003 in cells a2,b2,c2. cells want values formatted text, preserve original fraction form. fractions represent error/total.

is possible? , how go doing this?

thanks lot!

since no-one responded , did not study found reply either:

fraction info in cell a1:

=left(a1;find("/";a1;1)-1) = numerator =mid(a1;find("/";a1;1)+1;9) = denominator

find return openoffice-calc fractions