Spreadsheet: 194310d1353099691-how-to-separate-a-single-column-of-text-cells-and-date-cells-complete-example
Sheet: Data Source

Tst Date | Name | Tst code | Tst score
2005-06-11 00:00:00 | 1 | 69 | 181
2005-02-05 00:00:00 | 2 | 5710 | 178
2005-02-05 00:00:00 | 2 | 5720 | 174
2005-02-05 00:00:00 | 2 | 5730 | 182
2003-04-26 00:00:00 | 3 | 710 | 176
2003-04-26 00:00:00 | 3 | 720 | 173
2003-04-26 00:00:00 | 3 | 730 | 175
2004-08-16 00:00:00 | 4 | 5710 | 169
2004-12-10 00:00:00 | 4 | 5710 | 176
2005-09-17 00:00:00 | 5 | 11 | 139
2005-09-17 00:00:00 | 5 | 12 | 146
2005-06-11 00:00:00 | 6 | 11 | 178
2005-06-11 00:00:00 | 6 | 12 | 146
2005-08-01 00:00:00 | 7 | 5710 | 166
2005-08-01 00:00:00 | 7 | 5720 | 167
2005-08-01 00:00:00 | 7 | 5730 | 165
2005-06-11 00:00:00 | 8 | 11 | 142
2005-06-11 00:00:00 | 8 | 12 | 146
2005-01-08 00:00:00 | 9 | 11 | 163
2005-01-08 00:00:00 | 9 | 12 | 156
2005-04-16 00:00:00 | 10 | 710 | 173
2005-04-16 00:00:00 | 10 | 720 | 170
2005-04-16 00:00:00 | 10 | 730 | 171
2005-07-15 00:00:00 | 11 | 5710 | 164
2005-07-15 00:00:00 | 11 | 5720 | 172
2005-07-15 00:00:00 | 11 | 5730 | 175
2005-08-18 00:00:00 | 11 | 5710 | 176
2005-08-19 00:00:00 | 11 | 5720 | 171
2004-12-31 00:00:00 | 12 | 5710 | 168
2004-12-31 00:00:00 | 12 | 5720 | 165
2004-12-31 00:00:00 | 12 | 5730 | 175
2005-07-21 00:00:00 | 12 | 5710 | 168
2005-07-27 00:00:00 | 12 | 5720 | 168
2005-01-08 00:00:00 | 13 | 100 | 670
2005-01-08 00:00:00 | 14 | 49 | 120
2005-09-17 00:00:00 | 14 | 49 | 152
2005-04-11 00:00:00 | 15 | 5710 | 169
2005-04-11 00:00:00 | 15 | 5720 | 172
2005-04-11 00:00:00 | 15 | 5730 | 171
2005-06-03 00:00:00 | 16 | 5710 | 165
2005-06-03 00:00:00 | 16 | 5720 | 170
2005-08-08 00:00:00 | 16 | 5720 | 173
2005-10-31 00:00:00 | 16 | 5710 | 167
2005-08-12 00:00:00 | 17 | 5710 | 177
2005-08-12 00:00:00 | 18 | 5720 | 175
2005-08-12 00:00:00 | 19 | 5730 | 183
2005-11-11 00:00:00 | 20 | 5710 | 183
2005-11-11 00:00:00 | 20 | 5720 | 174
2005-11-11 00:00:00 | 20 | 5730 | 172
2004-11-20 00:00:00 | 21 | 191 | 177
2004-11-20 00:00:00 | 21 | 192 | 161
2003-06-28 00:00:00 | 22 | 710 | 171
2003-06-28 00:00:00 | 22 | 720 | 169
2003-06-28 00:00:00 | 22 | 730 | 173
2005-11-19 00:00:00 | 23 | 720 | 172
2005-06-11 00:00:00 | 24 | 11 | 147
2005-06-11 00:00:00 | 24 | 12 | 149
2005-07-14 00:00:00 | 25 | 5710 | 174
2005-07-14 00:00:00 | 25 | 5720 | 171
2005-07-14 00:00:00 | 25 | 5730 | 178
2005-08-01 00:00:00 | 25 | 5710 | 177
2005-08-02 00:00:00 | 25 | 5720 | 171
2005-09-07 00:00:00 | 25 | 5720 | 175
2005-06-11 00:00:00 | 26 | 710 | 171
2005-06-11 00:00:00 | 26 | 720 | 178
2005-06-11 00:00:00 | 26 | 730 | 177
2005-05-19 00:00:00 | 27 | 5720 | 169
2005-04-16 00:00:00 | 28 | 61 | 104
2005-04-16 00:00:00 | 29 | 65 | 100
2005-04-16 00:00:00 | 30 | 730 | 175
2005-06-11 00:00:00 | 31 | 353 | 188
2005-06-11 00:00:00 | 31 | 542 | 173
2005-09-15 00:00:00 | 32 | 5710 | 175
2005-09-15 00:00:00 | 32 | 5720 | 175
2005-09-15 00:00:00 | 32 | 5730 | 177
2005-11-19 00:00:00 | 32 | 710 | 176
2005-06-11 00:00:00 | 33 | 710 | 164
2005-06-11 00:00:00 | 33 | 720 | 173
2005-06-11 00:00:00 | 33 | 730 | 171
2005-06-11 00:00:00 | 33 | 720 | 173
2005-06-11 00:00:00 | 33 | 730 | 171
2005-11-19 00:00:00 | 33 | 5710 | 174
2005-11-19 00:00:00 | 33 | 5730 | 174
2005-11-19 00:00:00 | 33 | 5730 | 174