View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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