Forum Discussion
How to split cell containing FRACTION into two cells including Numerator and denominator
- Apr 20, 2022
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
- Riny_van_EekelenApr 20, 2022Platinum Contributor
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.
- ESAM_HASHIMApr 20, 2022Brass ContributorPlease can you tell me how to PASTE SPECIAL as text to make the formula possible, because I didn't find any way rather than inter all required fractions MANUALLY to apply the specified formulas, you can copy the example sheet to a new sheet to be more understand your idea
Much apricated.- Riny_van_EekelenApr 20, 2022Platinum Contributor
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.