Extracting Month and Year from Date

There is a column for dates from which i need to get month and year accordingly into another column.

The temporary solution for me worked out to be

=CONCATENATE(MONTH(A1),"-",YEAR(A1))

A1 has a date entered.This would have been fine if it were not for the result in number format i.e. I get something like "5-2007" and I need the display to be just "May - 07"

Is there any other way for this? And also how to convert the output from Month() function to display Month Name rather than the in number.

Thanks
Karthik

Try

=TEXT(A1,"mmmm - yy")

thanks a lot daddylonglegs. Worked like a Charm.
and sweep the formula you had returns an error when coming to year..thanks for the effort though

Hi
this command worked for me =TEXT(A1,"mmmm - yy"). But then I need to sort it by date and it is not working. I need the dates to be in an ascending order. Any ideas?

BEst,
MArvin