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"))
ESAM_HASHIM Please see attached.
Thank you very much Riny_van_Eekelen
I can conclude from your file the following critical points to apply the two formula correctly as shown by replied file that attached here:
1, The first step is to change Format Cells in all empty cells to be Text format
2. Then I must inter all required fractions MANUALLY because (as concluded) Excel cannot accept all options in copy pest at all
From all above points please, I need to verify my idea
Warm Regards