Reply to Message

Thank you for the excellent explanation of how this works.Is there a variant on this formula to solve the problem I have.

This problem is I have a list of bookmakers prices in a column of cells.
e.g.

6/1
9/4
16/1
13/2
11/10 etc....

I can use the above formula to extract the number to the right or left of the / in any given price,however,if I need both numbers to the right or left I have to change the formula.Is there a single formula that will display however many numbers to the right or left of the /.As I load different sheets of info the fraction in the cell is changing,hence my problem.

again,great info
regards, martin martinsemail2000@yahoo.co.uk