Extracting Numerator and Denominator to Difference Cells

[Taylorxu]

Hello,

I am attempting to extract both the numerator and denominator of a fraction into separate individual cells.
For example, a fraction of 209/69, I am seeking your assistance in a formula that can have the 209 and 69 in two separate cells. The fraction varies from one digit in the numerator to three digits in the numerator.

I have been using =LEFT(TEXT(MOD(A1,1),"#/##"),FIND("/",TEXT(MOD(a,1),"#/##"))-1) for the numerator and it is not working constantly with differentiating numerators.

Any assistance would be appreciated.

Thank you

 

[Taylorxu]

Thank you, that works!

 

[Marcelo Branco]

Thank you, that works!

Which formula have you used?

M.

 

[Taylorxu]

Numerator
=LEFT(TEXT(A1,"###/###"),SEARCH("/",TEXT(A1,"###/###"))-1)

Denominator
=MID(TEXT(A1,"###/###"),SEARCH("/",TEXT(A1,"###/###"))+1,3)

With the fraction cell being formatted ###/##

 

[Marcelo Branco]

Ok. Glad to help

M.