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

[Roadie]

Try this:
=A1&TEXT(B1,"dd/mm/yy")

[Oliver Ferns via OfficeKB.com]

Hi
Try this...

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

Cheers,
Oli

--
Message posted via http://www.officekb.com

[Oliver Ferns via OfficeKB.com]

I meant...

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


but you get the picture!

O

--
Message posted via http://www.officekb.com

[Biff]

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