Hi,

column A contains the word Jan or Feb, or...
column B contains a year
how can I combine them into a date which I can sort chronologically?


A B C
DEC 1998 should become e.g. Dec-98
DEC 1998
JAN 1997
JAN 1997
FEB 1997
MAR 1997
APR 1997
APR 1997
MAY 1997


Thanks!

tom