If you select any cell in the column containing entries like "21-Aug" and
look at the formula bar, you will probably find its a Date and already has a
year attached to it... the current year. If it is possible that this
column's year is not the correct one, you can do this to join its month and
day with your other column's year value. Assuming your "first column" is A
and your "second column" is B....

=DATE(B1,MONTH(A1),DAY(A1))

Rick


wrote in message
...
I have two columns that I want to merge into one. The first column is
as month day column 21-Aug and the second column is a year column, ie
2003. Is there a way to merge the two together? I have tried the
CONCATENATE and the merge functions without success. I am a fairly
novice/infrequent user of Excel.

Thanks.