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

 

[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]

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

 

[Jarek Kujawa]

oops, sorry

corrected:

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

 

[Jarek Kujawa]

oops, sorry

corrected:

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