Use help from the following link to split text into diff parts
http://office.microsoft.com/en-us/ex...549011033.aspx
Then use the date func to convert the text to date



"Geoff" wrote:

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