LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"