Sorting...

M

Mike

I am trying to sort a csv list.
The first column is a date & the 2nd is time.
Can I merge these 2 together, so I can get date & time together, allowing me
to sort based on that?
 
D

Dave Peterson

If they're really dates and times, you could just use a helper cell and then use
a formula like:

=a1+b1
You can give it a nice format showing date and time if you like.

But why not just sort the list using the date as the primary key and the time as
a secondary key?
 
M

Mike

Because I'm an Excel dummy & didn't know you could do it that way.
Thanks, that got me what I wanted!
 
Top