Combining 2 cells to 1

Solved/Closed
-
 Shashi -
Hi,

I have data like below in two column of excel sheet:

1-Jan | 2004
23-Jul| 2004
12-Feb|2003
................
.........

Out out required is 1-jan-04,
23-jul-04,
12-Feb-03
.........................so on.
Concatenation say =A1&B1 or =A1&&B1 didn't work......it gave the value 401802004...

Kindly help me to join these cells.

Thank you very much in advance.

--Shashi

2 replies

This is perfect!!!!!!!!!!!

thanks a lot.

Shashi
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Try this

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