Format 'General' year to actual year

[kiwichick]

I'm using Excel 2007 so I hope it's not too old to achieve what I'd like.

I have a table I've copied from online. The date column is formatted with each date separated into two cells, one above the other.
The first cell is formatted for 'Custom' d-mmm and the content is the day and month. For example: 17-Jun
The second cell is formatted for 'General' and the content is the year that goes with the above cell. For example: 2021

I want to merge them into a single cell but can't because they're different data values. How do I format these cells so they can be merged into a date of 17-Jun-2021? (The separator can be anything.) I thought I could just convert the year cell to 'Custom' yyyy but it didn't work. Instead of it staying 2021 it changed to 1905.

And, if it is possible, can I apply it to the whole column at once rather than doing each set of two cells separately?

 

[Phuoc]

Try this:

=DATEVALUE(TEXT(A2,"dd-mmm")&"-"&B2)

 

[kiwichick]

Try this:

=DATEVALUE(TEXT(A2,"dd-mmm")&"-"&B2)

Thanks, that worked great

 

[kiwichick]

Try this:

=DATEVALUE(TEXT(A2,"dd-mmm")&"-"&B2)

I forgot to mention that I did have to change the format of the new, merged cell to Date. And once I've applied this to all the relevant cells, what do I need to do so that I can delete the original column?

 

[Phuoc]

You can copy and paste values, and then delete the original column

 

[kiwichick]

You can copy and paste values, and then delete the original column

Thanks again