ExcelBanter - How can I extract name of the LONG MONTH from previous cell.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I extract name of the LONG MONTH from previous cell. (https://www.excelbanter.com/excel-worksheet-functions/105778-how-can-i-extract-name-long-month-previous-cell.html)

amit

How can I extract name of the LONG MONTH from previous cell.

How can I extract name of the month (MMMM) from the previous cell while using
EXCEL 2003.

Niek Otten

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.

Gary''s Student

How can I extract name of the LONG MONTH from previous cell.

Use formatting:

Format Cells... Number Custom and then use mmmm
--
Gary's Student

"AMIT" wrote:

How can I extract name of the month (MMMM) from the previous cell while using
EXCEL 2003.

All times are GMT +1. The time now is 12:53 AM.