Help on Concatenate

[kiran]

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

 

[Oliver Ferns via OfficeKB.com]

Hi
Try this...

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

Cheers,
Oli

 

[Oliver Ferns via OfficeKB.com]

I meant...

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


but you get the picture!

O

 

[Biff]

Hi!

Try this:

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

Biff