Extracting month as text

[andy wilson]

Hi,

In A1 I have 21-dec-05

I need to get the month into E1 as dec

Any ideas?

 

[Guest]

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

Andy.