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

Try something like:

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

HTH
JG

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
>

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