Hi,

Thanks for this the suggested formula works fine (and I will mark this solved later). Just for my own understanding I take it the =TRIM(LEFT(M2,2)) is to allow for a double digit score with the left(m2,2) and the trim command cuts off the space if it is only one digit? With the other formula I am figuring the search is in their to effectively set the trim to the right of the ":" with the +1 to account for the space between the : and the number? Sorry for asking a further question I just want to try and fully understand the process for myself.

Thanks,