Format Month from String (2000)

[JMac]

This seems so easy... but it's killing me.

Cell A1 has a string, value "200206", representing year 2002, and month 06 (June).

I want to put a formula in cell A2 that will look to the contents of cell A1 and display "June 2002". When A1 has "200112", A2 should display "December 2001".

It seems simple, but it has eluded me. I can get it to go with the CHOOSE function, but that requires me to put in the values for each of the months. I'm trying to use the FORMAT(WhateverValueInCellA1, "Mmmm yyyy"). I always end up with #NAME? in A2.

Is there an elegant solution?

[rory]

Hi,
If your data is in A1 then the following formula will produce what you want:
=TEXT(RIGHT(A1,2)&"/"&LEFT(A1,4),"mmmm yyyy")
Hope that helps.

[JMac]

Right on, Right on!

That's perfect. Thank you, thank you, thank you.

JMac