Downside to CONCATENATE is that it will bomb with more than 30 arguments (Possibly not a problem with your data), and is unncessary given that =A1&B1 will do the same more efficiently. Leslie's answer was the one you should use.
i have tried this with date & time, and excel returns a serial number for the date and the time in the merged cell.
can anyone tell me how i get arounf this please?
Thanks, sorry to be a pain but it doesn't work when i format the "merged" cell as date and time - the serial number still remains.
The workround i have is that the date and time in a1 & b1 are placed in "", which is ugly and, i guess, will not work when i use a pop-up calender.
my example is:
a1 b1 c1
08-Apr-03 16:05 377190.670138888888889
where c1 = =E1&""&F1
Use an 'ADD' operator:
a1 b1 c1
08-Apr-03 16:05 08-Apr-03 16:05
Here c1 = a1 + b1
Value in c1 will be proper only if
1. a1 and b1 are entered (not formatted) as date and time respectively. The idea is that value for a1 must not contain a time reference and that for b1 must not contain any date reference.
2. c1 is formatted as date-time string.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.