How do I copy part of a text string?

**knighttrader** · 01-28-2008, 02:48 AM

I want to copy the time from within a text string. The problem is that the time will be placed at a different position depending on the length of the preceding text. In the first example below, the time is placed 16 characters from the left and 17 from the left in the second.

examples:

Sthl 7th Jan - 22:55 2m Hcap Hrd

Sthl 27th Jan - 22:55 2m Hcap Hrd

The only constant is "-" before the time.

Anyone have any ideas for I can extract the time?

Many thanks