Hey,
This formula = =CONCATENATE(A1," ",B1) is the best solution.
Incase u cannot see the date, then , righ click on the resultant cel
and select format cells and select text or keep it default as general.
Try it out.
archeti Wrote:
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 i
cell C1
reads:
"john 123456", where '123456' represents an integer by which Exce
repesents
the date!
any ideas of how to make the date appear in the form dd.mm.yyyy? I'v
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
--
dp
-----------------------------------------------------------------------
dpt's Profile:
http://www.excelforum.com/member.php...fo&userid=2586
View this thread:
http://www.excelforum.com/showthread.php?threadid=48273