Combining 2 cells to 1

Solved/Closed
Shashi - 13 May 2010 à 04:36
 Shashi - 13 May 2010 à 07:44
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
Related:

2 responses

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

thanks a lot.

Shashi
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 May 2010 à 07:34
Try this

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