ExcelBanter - Extracting month as text

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

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

- - Extracting month as text (https://www.excelbanter.com/excel-worksheet-functions/60177-extracting-month-text.html)

andy wilson

Extracting month as text

Hi,

In A1 I have 21-dec-05

I need to get the month into E1 as dec

Any ideas?
--
Cheers

Andy

Extracting month as text

See answer in misc - and please don't multipost.

Andy.

"andy wilson" wrote in message
...
Hi,

In A1 I have 21-dec-05

I need to get the month into E1 as dec

Any ideas?
--
Cheers

Andy

All times are GMT +1. The time now is 01:55 PM.