Please help with "concatenate".
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
|