Forum Discussion
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...
Try this.
=TRANSPOSE(FILTERXML("<y><z>"&SUBSTITUTE(SUBSTITUTE(TEXT(B8,"# ????/????"),"/","#"),"#","</z><z>")&"</z></y>","//z"))
Thank you Riny_van_Eekelen so much for your generosity
Please let me to explain the steps that applied by going to My_Worksheet file
1. Firstly, I pasted the Column A from another worksheets after changing the format cell to view fractions
2. I got the values shown in B column by 2 equations shown in the file
3. I have repeated values shown in column E MANUALLY from B column to be able to apply the two formulas in columns F & G
My question was are there another way rather than repeat values manually in column E to be able to split all cells as shown in columns F & G
Try this.
=TRANSPOSE(FILTERXML("<y><z>"&SUBSTITUTE(SUBSTITUTE(TEXT(B8,"# ????/????"),"/","#"),"#","</z><z>")&"</z></y>","//z"))Detlef_Lewin How to get only the denominator?
I found it, thanks
Thank you so much Detlef_Lewin
I highly appreciate the info. This will help me enormously.
