Please help with "concatenate".

U

usmleboy

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
 
Top