Forum Discussion

ESAM_HASHIM's avatar
ESAM_HASHIM
Copper Contributor
Apr 20, 2022
Solved

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...
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Apr 20, 2022

    ESAM_HASHIM 

    Try this.

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

Resources