How to add a singe symbol to the whole column data?
 

Dear Friends,

I have a simple problem. In my spreadsheet there are 8 columns and 18.000
rows. I need to combine two colums "date of birth" and "sample date", but
between them there should be "c":

Ex:
Date of Birth Sample Date
[10/01/1960] [10/10/2005]

I do not know how to create new column like this:

[10/01/1960 c 10/10/2005]

Thanks in advance
Daniel

How to add a singe symbol to the whole column data?
 

Try something like this:

C1: =A1&" c "&B1


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"usmleboy" wrote:

Dear Friends,

I have a simple problem. In my spreadsheet there are 8 columns and 18.000
rows. I need to combine two colums "date of birth" and "sample date", but
between them there should be "c":

Ex:
Date of Birth Sample Date
[10/01/1960] [10/10/2005]

I do not know how to create new column like this:

[10/01/1960 c 10/10/2005]

Thanks in advance
Daniel

How to add a singe symbol to the whole column data?
 

Try something like:

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

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498838

How to add a singe symbol to the whole column data?
 

Combine the 2 columns - then do a Find and Replace
Find ] [
Replace with: c


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498838