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"))
PeterBartholomew1
Thank you for your trial to help me but I would like to inform you that the formula provided by Detlef_Lewin is the most practical for my situation
I try to apply your formulas in My_Worksheet file but without any positive results, that's may be due to I am not expert in using those formulas you used in your example (fractions.xlsx)
Kind Regards
Don't feel bad about it. You have to be a 365 user, signed up to the beta channel, for those particular formulas to work. I post them because exploring new functionality interests me and in order to seed the idea that tomorrow's spreadsheet solutions may be very different from yesterday's.
I feel that there are the more covering info about my request to be as a best reference
you are most welcome, don't worry about my feeling
Have a nice day!