Dear All,
both versions of concatenation work BUT, in the case of the example
specified, that is:

"john" in cell A1
"01.01.2006" in cell B1,

the date gets converted into an integer such that the end result in cell C1
reads:

"john 123456", where '123456' represents an integer by which Excel repesents
the date!

any ideas of how to make the date appear in the form dd.mm.yyyy? I've tried
customising cell C1 accordingly but so far I did not manage.

pls help
thanks


"NITESH G" wrote:


Hi Venkat
try this formula in C1
= concatenate(a1," ",b1)


--
NITESH G
------------------------------------------------------------------------
NITESH G's Profile: http://www.excelforum.com/member.php...o&userid=17590
View this thread: http://www.excelforum.com/showthread...hreadid=482731