In article , Ron Rosenfeld
writes
Assuming that the entry is a normal Excel date, and not a text string, then:

=UPPER(TEXT(C3,"mmm"))

would return APR

HI

OK Thanks for your help. This works perfectly first time.


^_^


Best Wishes