I have a column of about 1000 dates in Excel 2000, all of them entered in
text format..
All the dates are different and written as in the following example:

20Feb1950
8Jul1980
1990
4Jan1979
etc

How can I separate just the year & place it in one column and the day and
month in another? I am having difficuly because the day has either 1 or 2
digits and some cells have only the year.

Any help would be much appreciated.

Geoff