How to sort rows by date AND time

[Brandi07]

Hello everyone. What I am looking to do is sort the rows in my spreadsheet by date AND time. The cells also contain other data however. For example there is a date 7/23/14 4:45 PM which is then followed by text. Each cell is set up this way. I entered them in ascending order but now I want to change that to descending order. There are a lot of rows that this must be done for so I am hoping there is a way to do them all at once as well...is there a way to do this that is not overly complicated? I have been searching around and cannot find anything. Thanks.

 

[NeonRedSharpie]

Split it into two columns. Can you paste a few sample values? Then I can let you know how to split the data.

 

[Brandi07]

Split it into two columns. Can you paste a few sample values? Then I can let you know how to split the data.

What do you mean-like split each cell up, the date/time from the text? If that is the case that really would not work as the information needs to all stay together, and that would create way too many columns. If I am misunderstanding please let me know.

 

[NeonRedSharpie]

What do you mean-like split each cell up, the date/time from the text? If that is the case that really would not work as the information needs to all stay together, and that would create way too many columns. If I am misunderstanding please let me know.

Then you can't really do it without adding columns. You can always hide the column or delete it after you've sorted the data.

 

[oldbrewer]

are your date times real dates and times or just text

 

[Brandi07]

are your date times real dates and times or just text

They are real dates and times in numeric format.