Splitting 2 Dates and Text from One Cell to 3 columns

[earthworm]

Dear All,

I have a huge data , set like this

in Cell A1

13 2 2011 13 2 2011 ABCDEF

Spaces and Gap may vary from cell to cell

I want to break all these in 3 seperate columns how can i achieve this
sample sheet attached

Green highlighted is the one which i want . i want this to appear using formula.how to do this.


http://www.box.net/shared/qq0qne1yxa

 

[stefankemp]

What date range is covered by the data? Is it all in 2011?

 

[earthworm]

What date range is covered by the data? Is it all in 2011?

any date
whether its 2011 or 2010 depends on the data date which i extract from system.

 

[stefankemp]

can it go back many years or is it just 2010 or 2011?

 

[earthworm]

can it go back many years or is it just 2010 or 2011?

it can before 2000 and after 2000 as well

 

[earthworm]

bump...