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

=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


"aditya" wrote:

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

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


On 29 Maj, 08:20, aditya wrote:
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

oops, sorry

corrected:

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




On 29 Maj, 08:36, Jarek Kujawa wrote:
=UPPER(TEXT(MID(A1,7,2),"mmmm"))

On 29 Maj, 08:20, aditya wrote:



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- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

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.]
--
David Biddulph

"Jarek Kujawa" wrote in message
...
=UPPER(TEXT(MID(A1,7,2),"mmmm"))


On 29 Maj, 08:20, aditya wrote:
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