theokaygadsby
New Member
- Joined
- Mar 14, 2018
- Messages
- 2
Hello, thank you for reading.
I'm working with dates that are exported from Kibana like this:
<tbody>
</tbody><colgroup><col></colgroup>
I'm working with dates that are exported from Kibana like this:
February 9th 2018, 18:00:00.000 |
I have tried using |
=LEFT(A1,FIND(",",A1)-1)) and various combinations of the TEXT and DATEVALUE functions, and have not been able to get the value recognized as a date. my goal is to extract the date into one column and the time into another and be able to sort on date, and format as different date formats as needed. |
<tbody>
</tbody><colgroup><col></colgroup>