splitting text in a cell into adjacent cells

[zeekmcphee]

hello,
In column A I have a couple of hundred cells with data ,there are no blank cells,The text is layed out like this

monday 12:55 february.

with days of the week,times and month varying....
I am looking for a way to keep monday in ColA,the time in ColB and the month in ColC,then loop down the entire column to the end.
Either vba or a formula solution would help.The only constant in the text is the time which is always 4 letters long(five including the :
hope this makes sense.Any ideas much appreciated
thanks
zeekmcphee

 

[etaf]

can you use DATA>TEXT TO COLUMNS to convert to 3 columns

 

[sandy666]

Data - Text to Columns (with space as delimiter)

edit : too late ?

 

[zeekmcphee]

Thanks both for your reply,I had forgotten all about the Text to column facility