Combining 2 cells to 1

Solved/Closed
Shashi - May 13, 2010 at 04:36 AM
 Shashi - May 13, 2010 at 07:44 AM
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
1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 13, 2010 at 07:34 AM
Try this

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