ExcelBanter - How do I sort the contents of cells in each row into ascending(earliest to latest) order

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I sort the contents of cells in each row into ascending(earliest to latest) order (https://www.excelbanter.com/excel-discussion-misc-queries/453581-how-do-i-sort-contents-cells-each-row-into-ascending-earliest-latest-order.html)

GARYWC

How do I sort the contents of cells in each row into ascending(earliest to latest) order

My spreadsheet has 5,000 rows.

Here are the contents of the cells in row 2:

B2 2015:12:25 14:43:31
C2 2015:12:25 14:01:38
D2 2016:04:23 06:49:44
E2 2016:04:23 06:49:44
F2 2015:12:25 14:43:31
G2 2015:12:25 14:43:31

All times are GMT +1. The time now is 09:03 AM.