Spreadsheet: 758934d1639158792-problem-using-mid-function-to-parse-a-string-with-slash-midfunctionparseproblem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Function with adjusted values taking hidden characters into account
 |  |  |  |  |  |  |  |  |  | =DATE(VALUE(MID(I6,10,4)),VALUE(MID(I6,2,2)),VALUE(MID(I6,6,2)))
 | Level | Date and Time | Source | Event ID | Task Category | Log | Description |  |  |  | =VALUE(J6)
 | Error | 2021-12-10 07:00:06 | EventLog | 6008 | None | System | The previous system shutdown at 03:07:47 AM on ‎12/‎10/‎2021 was unexpected. | ‎12/‎10/‎2021 | 03:07:47 AM
 | Error | 2021-12-06 07:44:11 | EventLog | 6008 | None | System | The previous system shutdown at 01:21:51 AM on ‎12/0‎6/‎2021 was unexpected. | ‎12/‎06/‎2021 | 01:21:51 AM
 | Error | 2021-12-05 18:01:39 | EventLog | 6008 | None | System | The previous system shutdown at 03:03:25 PM on ‎12/‎04/‎2021 was unexpected. | ‎12/‎04/‎2021 | 03:03:25 PM
 | Error | 2021-12-04 09:03:13 | EventLog | 6008 | None | System | The previous system shutdown at 08:20:26 AM on ‎12/‎04/‎2021 was unexpected. | ‎12/‎04/‎2021 | 08:20:26 AM
 | Error | 2021-12-03 08:20:16 | EventLog | 6008 | None | System | The previous system shutdown at 08:05:29 AM on ‎12/‎03/‎2021 was unexpected. | ‎12/‎03/‎2021 | 08:05:29 AM
 | Error | 2021-12-02 08:45:23 | EventLog | 6008 | None | System | The previous system shutdown at 08:07:55 AM on ‎12/‎02/‎2021 was unexpected. | ‎12/‎02/‎2021 | 08:07:55 AM
 | Error | 2021-11-17 11:39:03 | EventLog | 6008 | None | System | The previous system shutdown at 10:58:40 AM on ‎11/‎17/‎2021 was unexpected. | ‎11/‎17/‎2021 | 10:58:40 AM
 | Error | 2021-11-04 07:03:28 | EventLog | 6008 | None | System | The previous system shutdown at 09:48:23 PM on ‎11/‎03/‎2021 was unexpected. | ‎11/‎03/‎2021 | 09:48:23 PM
 | Error | 2021-10-20 10:29:17 | EventLog | 6008 | None | System | The previous system shutdown at 10:19:15 AM on ‎10/‎20/‎2021 was unexpected. | ‎10/‎20/‎2021 | 10:19:15 AM
 | Error | 2021-10-12 13:19:03 | EventLog | 6008 | None | System | The previous system shutdown at 01:01:02 PM on ‎10/‎12/‎2021 was unexpected. | ‎10/‎12/‎2021 | 01:01:02 PM
 | Error | 2021-09-08 11:03:13 | EventLog | 6008 | None | System | The previous system shutdown at 10:53:32 AM on ‎09/‎08/‎2021 was unexpected. | ‎09/‎08/‎2021 | 10:53:32 AM
 | Error | 2021-09-07 17:33:31 | EventLog | 6008 | None | System | The previous system shutdown at 04:54:40 PM on ‎09/‎07/‎2021 was unexpected. | ‎09/‎07/‎2021 | 04:54:40 PM
 | Error | 2021-06-27 11:08:07 | EventLog | 6008 | None | System | The previous system shutdown at 09:05:51 AM on ‎06/‎26/‎2021 was unexpected. | ‎06/‎26/‎2021 | 09:05:51 AM
 | Error | 2021-06-02 12:54:39 | EventLog | 6008 | None | System | The previous system shutdown at 12:36:45 PM on ‎06/0‎2/‎2021 was unexpected. | ‎06/‎02/‎2021 | 12:36:45 PM
 | Error | 2021-03-24 20:01:06 | EventLog | 6008 | None | System | The previous system shutdown at 07:51:01 PM on ‎03/‎24/‎2021 was unexpected. | ‎03/‎24/‎2021 | 07:51:01 PM
 | Error | 2021-02-18 17:25:07 | EventLog | 6008 | None | System | The previous system shutdown at 05:19:10 PM on ‎02/‎18/‎2021 was unexpected. | ‎02/‎18/‎2021 | 05:19:10 PM
 | Error | 2021-01-20 07:53:28 | EventLog | 6008 | None | System | The previous system shutdown at 06:19:44 PM on ‎01/‎19/‎2021 was unexpected. | ‎01/‎19/‎2021 | 06:19:44 PM
 |  |  |  |  |  |  | Lines copied from Event Viewer, pasted into Excel, then copied and pasted  into CodeWright (shows the hidden/invisible extra characters in the date):
 |  |  |  |  |  |  |  | Text string | Function | Output
 |  |  |  |  |  |  | Copied/Pasted value: | ‎12/‎10/‎2021 | =LEN(I30)
 |  |  |  |  |  |  | Freshly typed in value: | 12/10/2021 | =LEN(I31)
 |  |  |  |  |  |  |  | Text string | Function | Output
 |  |  |  |  |  |  |  | 12/10/2021 | =VALUE(I32)
 |  |  |  |  |  |  |  | 03:07:47 AM | =VALUE(I33)