Concatenate question

P

Paul Gurdin

Hi Bob

You need to input into the cell in column c as follows:

=value(concatenate(text(a1,"dd-mm-yyyy")&" "&text
(b1,"hh:mm")))

You can then format the cell to date and time.

I've checked this on my excel and it works.

Hope this helps. Let me know how you get on.

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Format 10
Concatenate cells with line breaks in them 4
Date Formats 4
Date and Time Conversion 3
Date format problems after csv import 4
Searching the formula (not the value) for a text string 1
help with format change of date part of concatenate formula 1

Top