Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If I correctly understand your described application I think you do not need to concatenate columns. If you use menu "Data", "Sort" then you can set three different columns to use for sorting. Set the sort columns in the order of Date, AM/PM and then Time and this should sort the data as required.