Extracting specific text from a text string

[richardthelionheart]

<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>
[TD="class: xl66, width: 288"] Deano Mixa 12:54 Romford
[/TD]
[TD="class: xl64, width: 42"]UK >[/TD]
[TD="class: xl65, width: 48"]12:54[/TD]

[TD="class: xl66"] Prime The Rank 19:11 Sunderland
[/TD]
[TD="class: xl64"]UK >[/TD]
[TD="class: xl65"]19:11[/TD]

[TD="class: xl63"] Aulton Rumble 21:37 Peterborough
[/TD]
[TD="class: xl64"]UK >[/TD]
[TD="class: xl65"]21:37[/TD]

[TD="class: xl63"] Honour Express 21:26 Doncaster
[/TD]
[TD="class: xl64"]UK >[/TD]
[TD="class: xl65"]21:26
[/TD]

</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.