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

[Guest]

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

 

[Guest]

Try something like this:

C1: =A1&" c "&B1


Does that help?

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

XL2002, WinXP-Pro

 

[pinmaster]

Try something like:

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

HTH
JG

 

[wjohnson]

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