=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