Extracting specific text from a text string

[richardthelionheart]

Deano Mixa 12:54 Romford	UK >	12:54
Prime The Rank 19:11 Sunderland	UK >	19:11
Aulton Rumble 21:37 Peterborough	UK >	21:37
Honour Express 21:26 Doncaster	UK >	21:26

<colgroup><col style="mso-width-source:userset;mso-width-alt:10532;width:216pt" width="288"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1755;width:36pt" width="48"> </colgroup><tbody>
</tbody>

Thanks to FormR who supplied me with -
=TRIM(LEFT(SUBSTITUTE(MID(D189,FIND(" 1"," "&SUBSTITUTE(D189,"2","1")),LEN(D189))," ",REPT(" ",5)),5))
I am able to extract the 'numbers' from the text string as can be seen here.
But I'd like to go a step further. Is it now possible to extract the names following the 'nimbers' I wonder. ie Romford, Sunderland, Peterborough and Doncaster ?? I would be happy to settle for the first 4 letters in each one if option A is not possible. Any help greatly appreciated.

 

[zaska]

Try this

=TRIM(MID(I10,FIND(":",I10,1)+3,LEN(I10)-FIND(":",I10,1)))

 

[richardthelionheart]

Thank You zaska - yep, it works perfectly !!

 

[zaska]

Thanks for the feedback.