Help on Concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I meant...

=A1&TEXT(B1,"DD-MM-YYYY")


but you get the picture!

O
 
Back
Top