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"))
Using the latest version of 365, two separate columns might be
= TEXTBEFORE(TEXT(values,"????/????"),"/")
= TEXTAFTER(TEXT(values,"????/????"),"/")or to combine the two columns into a single 2D array
= LET(
fraction, TEXT(values,"????/????"),
numerator, TEXTBEFORE(fraction,"/"),
denominator, TEXTAFTER(fraction,"/"),
CHOOSE({1,2},numerator,denominator)
)The original values were numbers rather than text and the number format uses improper fractions.
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!