View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 110
Default concatination of cell contents

A1&" " &B1
space between two apostrophes


"archeti" wrote in message
...
pls help with a simple query.

I need to concatinate the contents of two cells into a third cell. For
example,
if cell A1 = "john" and cell B1 = "01.01.2006", I need cell C3 to contain
"john 01.01.2006".

What kind of formula should cell C3 contain?

thanks in advance