cahnge text

  fastbuck 01:30 13 May 2014
Locked

Hi, I have a column full of info as follows. The info is in single cells in excel 2007. A1. Race 1 GRC Function & Event Centre F&M Maiden Plate 1900m 12:10 A2. Race 2 APCO Service Stations 3YO Maiden Plate 1900m 12:45 pm

I want the time to be at the beginning as follows: A1. 12:10 pm Race 1 GRC Function & Event Centre F&M Maiden Plate 1900m A2. 12:45 pm Race 2 APCO Service Stations 3YO Maiden Plate 1900m

Is there a formula I can use to do this. Thanks in advance

  wiz-king 16:23 13 May 2014

Don't think so.

  fastbuck 20:39 13 May 2014

What about a way to put the time into another column. I've tried text to column but because the entries are different lengths and staggered. It doesn't work.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?