Hello,

I am using Windows XP with Office XP. I have two columns. Column A
contains months of the year in the format January, March December etc.
Column B contains dates in the format 11th, 16th, 20th etc.
Is it possible to combine these two cells to produce a date? Can a
sort then be undertaken on this new date column so that all
information is sorted chronologically?
I tried using concatenate to combine the cells but couldn't get them
to be recognised as dates.
Thanks in advance for all your assistance.

Ket
London