Hi!

Try this:

=A1&" "&TEXT(B1,"dd-mm-yy")

Biff

-----Original Message-----
Hi All,
I have a data in col A and B as mentioned below .......
A B
Issued on 15-06-04
Baselined on 27-11-03
Released on 10-02-04
Issued on 15-06-04
Baselined on 13-01-05
Issued on 15-06-04

when i concatenate A & B i get result ..
Issued on 15-06-04 Issued on 38153
Baselined on 27-11-03 Baselined on 37952
Released on 10-02-04 Released on38027
Issued on 15-06-04 Issued on 38153
Baselined on 13-01-05 Baselined on 38365
Issued on 15-06-04 Issued on 38153

I want result in C column
Issued on 15/06/04

what is the solution for this

TIA
.