How to split cell containing FRACTION into two cells including Numerator and denominator

Hi everyone here If I have 4 cells containing the following fractions as example, my question is about the formula that can be applied for each for these cells to get two cells including Numerator a...

developer

excel

Formulas and Functions

Apr 20, 2022

Try this.

=TRANSPOSE(FILTERXML("<y><z>"&SUBSTITUTE(SUBSTITUTE(TEXT(B8,"#  ????/????"),"/","#"),"#","</z><z>")&"</z></y>","//z"))

Detlef_Lewin

Silver Contributor

Apr 20, 2022

ESAM_HASHIM

Try this.

=TRANSPOSE(FILTERXML("<y><z>"&SUBSTITUTE(SUBSTITUTE(TEXT(B8,"#  ????/????"),"/","#"),"#","</z><z>")&"</z></y>","//z"))

ESAM_HASHIM

Brass Contributor

Apr 20, 2022

Thank you so much Detlef_Lewin
I highly appreciate the info. This will help me enormously.

Forum Discussion

How to split cell containing FRACTION into two cells including Numerator and denominator