On Wed, 03 Nov 2004 17:03:02 +0000, Ket wrote:

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


=--(A1&" "&LEFT(B1,LEN(B1)-2))

or

=--(LEFT(B1,LEN(B1)-2)&" "&A1)

Of course, since the year is unspecified, it will always default to the current
year.




--ron