display month only

[aditya]

in cell A1 data is of 10 digit whose last 6 digit is in the form of ddmmyy.
i want to display only month name in cell B1

e.g. A1 B1
ACSD280509 MAY
RESG120309 MARCH

 

[Jacob Skaria]

=TEXT(DATE(VALUE("20" & RIGHT(A1,2)),MID(A1,7,2),MID(A1,5,2)),"MMM")

To convert that to date
=DATE(VALUE("20" & RIGHT(A1,2)),MID(A1,7,2),MID(A1,5,2))

If this post helps click Yes

 

[Jarek Kujawa]

=UPPER(TEXT(MID(A1,7,2),"mmmm"))

 

[Jarek Kujawa]

oops, sorry

corrected:

=UPPER(DATE(1,TEXT(MID(A1,7,2),1),"mmmm"))

 

[David Biddulph]

Er, no, Jarek.
The numbers 05 and 03 (from your use of MID) both return JANUARY from the
TEXT function, as they represent the dates 5 Jan 1900 and 3 Jan 1900
respectively.
Perhaps =UPPER(TEXT(TEXT(MID(A1,5,6),"00\-00\-00"),"mmmm")) ? [But this
relies on the appropriate setting of Windows Regional Options.]