Split runs from wickets in cricket score

Hi

I'm currently doing a project for uni where I need to get large amounts of cricket batting data in excel. One of the things I want to do is work out the average number of wickets taken per over. However, the data is in the form "230/7" where 230 is runs scored and 7 is wickets taken. Is there a way of separating the wickets from the runs ie just have a column with the number of wickets without the 230 or forwards slash?

Thanks
James

Strange Uni project !!

You can use this formula, assuming that text data is in A1:

=RIGHT(A1,LEN(A1)-FIND("/",A1))*1

Hope this helps.

Pete

Originally Posted by Pete_UK

Strange Uni project !!

You can use this formula, assuming that text data is in A1:

=RIGHT(A1,LEN(A1)-FIND("/",A1))*1

Hope this helps.

Pete

Thanks Pete that works great. However is there a way of showing the value '10' is there is no forwards slash?

The project is predicting the outcomes of cricket matches, not just wickets It's the very early stages so just wanting to create a few basic models before progressing into the more complex stuff.

Originally Posted by martindwilson

=iferror(mid(a1,find("/",a1)+1,2)+0,10)

Thanks for that, much appreciated.