seperating numbers into different columns

[newbee2013]

Hi Forum, I have another interesting problem. I have a column with random times that are not seperated by any commas or spaces how can i seperate them into different columns. For example in A1 i have 12:3213:5420:32 this represent three different times 12.32 13.54 and 20.32 (each time has the same format as shown) and i want to display these as B1=12:32 C1=13:54 and D1=20:32 then do the same for the rest of column A?

[martindwilson]

text to columns fixed width should do it

[newbee2013]

thanks that works brill!!

[Tony Valko]

One way...

Enter this formula in B1 and copy across to D1:

=--MID($A1,COLUMNS($B1:B1)*5-4,5)

Format as Time