Thread: How can I extract name of the LONG MONTH from previous cell.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default How can I extract name of the LONG MONTH from previous cell.
=TEXT(A1,"mmmm")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"AMIT" wrote in message ...
| How can I extract name of the month (MMMM) from the previous cell while using
| EXCEL 2003.


Reply With QuoteReply With Quote