Extract fraction from text

[davieross]

How can I extract a fraction from text?
e.g. Surf Dancer 4/7 Fav
I am looking to extract 4/7 in fraction format

[AliGW]

Welcome to the forum.

Based on the only example you've given us:

=TRIM(MID(A1,FIND("/",A1)-2),5))

[Special-K]

Is the fraction ever bigger than 1 e.g. could it be 3 7/8 (three and seven eighths) ?

[Special-K]

Welcome to the forum.

Based on the only example you've given us:

=TRIM(MID(A1,FIND("/",A1)-2),5))

Ali, does that formula work?
I'm getting "youve entered too few arguments" error
Its highlighting the 2 in your formula

[Special-K]

Ali's formula should be

=TRIM(MID(A1,FIND("/",A1)-2,5))

She added an extra bracket after the 2 which works when removed.

[AliGW]

Thanks - I write it on the fly!

As you correctly pointed out, it should be:

=TRIM(MID(A1,FIND("/",A1)-2,5))

[AlKey]

All formulas that were suggested, return text. However, if you need to calculate fractions use this formula.

=IFERROR(--("0 "&TRIM(MID(A1,FIND("/",A1)-2,5))),1)

v	A	B
1	Surf Dancer 4/7 Fav	4/7

Format cell B1 as Fractions

[davieross]

Hi Folks,
Thanks for all your replies
I have just come back in from work and tried the most recent option which works great.
Thanks Alkey

=IFERROR(--("0 "&TRIM(MID(A1,FIND("/",A1)-2,5))),1)

For those who are curious, I am pasting horse racing results from the web into a table, e.g. "Chica De La Noche 4/1" and then extracting the fractional odds to work out the returns.
And Alkeys formula is perfect for my purposes.
I will now look at the other options just to get a feel for the formula processes.

Thanks again for your prompt replies.

Alkey,
If you could provide a brief explanation of your formula function that would be great, thanks