parsing a date field

[carriex3]

I have data that was imported from another system (don't know what
system). The date field shows as 01-01-2005. I need to split the
field so that the month is one cell and the year in another (don't need
day). I tried the usual right(a1,2) type command, but I get 53
returned. I tried to first convert the date to text, but then I get
the full five digit date.

I'm sure that there is an easy solution to this, but I don't know what
it is and couldn't locate it in the board archives.

Thank you!!

Carrie

 

[Gord Dibben]

Assuming 01-01-2005 in A1

In B1 enter =MONTH(A1)

In C1 enter =YEAR(A1)

Copy and paste special>values then delete column A


Gord Dibben MS Excel MVP

 

[carriex3]

Thank you! So simple and it saved the day!