I saw your other thread and one suggestion seemed to me to be valid. You
don't need to concatenate anything.

To get just the date from R2

=INT(R2)

to get just the time from AA2

=AA2-INT(A2) or MOD(AA2,1) so to get the combination you just add
these, i.e.

=INT(R2)+MOD(AA2,1)

format as dd/mm/yy hh:mm

If AA2 is the result of some sort of LOOKUP formula then you can just
amend this to

=INT(R2)+MOD(formula,1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528925