Forum Discussion
How to split cell containing FRACTION into two cells including Numerator and denominator
Try this.
=TRANSPOSE(FILTERXML("<y><z>"&SUBSTITUTE(SUBSTITUTE(TEXT(B8,"# ????/????"),"/","#"),"#","</z><z>")&"</z></y>","//z"))
ESAM_HASHIM But you can copy and paste your list of fractions. First format the column as Text, and then paste special as text. That's how I did in in my example.
Much apricated.
ESAM_HASHIM Not sure I understand your question. But in order to help you further, I'd need to have some more info. Where do the fractions come from? I understood that you already had them in a list in Excel and needed to split them. If not, pease clarify.
I just copied the fractions from this forum page into my own Excel and needed to use paste special into a text column, but perhaps you don't have to do that at all.
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 & GMy 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"))