Extracting Text As A Number in a Betting Odds

Hi All,

I’m sure this kind of question has been asked before in this forum but I haven’t been able to find anything close. Plus, 3 days of working on this problem and I’m near to defeat!

So, the problem here is fairly straight forward. In the attached file are 3 columns; Stake placed in £ Sterling and the betting odds in column B. The first thing to note is that the odds need to be typed in and displayed as xx/y or x/yy or xx/yyy etc. So, this column is formatted as text to achieve this. This also may be the source of part of the problem.

What I need to do with column B is extract as a number before the slash / and after the slash so I can calculate the winnings on the stake placed. The maximum number of characters before and after the slash / will be no more than four but can occur in various combinations.

The problem for me I don’t know how to locate the position of the slash / and extract what is before and after it in any combination of characters before and after. If this is possible, can what is extracted then be treated as a number? Or, is my choice of formatting incorrect?

Hoping someone can help me. Many thanks in advance.

Beaten by T.V.

try this formulas

Thank you all for replying. I've some new formulae to study!