Please help with "concatenate".

[Guest]

Dear friends,

I am working with my clinical data now. There is one problem:

My spread sheet has two collumns and 2000 raws. Here is an example:

A B
====== =====
03/04/00 11/05/50
09/10/01 30/09/74
06/03/96 25/06/40

I have to combine these collumns with "c" between them. Expected result:

03/04/00 c 11/05/50

Unfortunatelly, my "concatenate procedure gives me not completelly desired
result:

030400 c 110550

Both collumns are formated for "date".

Please would you mind to help me how to resolve my problem.
Thanks in advance!

Daniel

 

[Gord Dibben]

=TEXT(A2, "mm/dd/yy") & " c " & TEXT(B2,"mm/dd/yy")


Gord Dibben MS Excel MVP

 

[Guest]

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