Thread: display month only
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aditya Aditya is offline
external usenet poster
  
Posts: 54
Default display month only
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
Reply With QuoteReply With Quote