Seperating Numbers

[gbrsml]

I'm new to excel and finding it hard to do the following, I wish to seperate a series of numbers into their own coloumns. The numbers are in the format 01:02:03.04 , Note numbers are seperated by colons and full stops. I gather I may need to convert them to text first but all my attempts convert the numbers into something completely different. Can anybody help ?

 

[xld]

Use Data>Text To Columns with : as a separator

 

[Peter_SSs]

I'm new to excel and finding it hard to do the following, I wish to seperate a series of numbers into their own coloumns. The numbers are in the format 01:02:03.04 , Note numbers are seperated by colons and full stops. I gather I may need to convert them to text first but all my attempts convert the numbers into something completely different. Can anybody help ?

Welcome to the MrExcel board!

If the data is uniformly 2-digits per section like your sample, then may be this formula, copied across?

Excel Workbook
	A	B	C	D	E
1	01:02:03.04	01	02	03	04
Separate Numbers

 

[gbrsml]

Sorry for the delay in this reply, I would just like to thank you for the help its greatly appreciated