What I would like to do is have Calc OpenOffice return the value of the denominator of a cell. I could do this with right or left, but then i'm constrained by the position.
Is there a way for me to find the denominator of a cell irrespective of the amount of digits in that cell?
So say i have three cells, A1, B1, C1. with values 1/3; 13/4; 1/1003, respectively I want Calc to return 3; 4; 1003 in cells A2,B2,C2. The cells I want to get the values from are formatted as text, so as to preserve their original fraction form. The fractions represent error/total.
Is this possible? And how would I go about doing this?
Thanks a lot!
Since no-one responded and you did not report that you found the answer either:
Fraction data in cell A1:
=LEFT(A1;FIND("/";A1;1)-1) = numerator
=MID(A1;FIND("/";A1;1)+1;9) = denominator