ibanez2727
MIS
Hi All,
I have some excel data with a text field that I'm trying to convert to a sortable date:
The field contains (ex. "4DEC13, 9:19" "18NOV13, 9:07" 15NOV13, 11:50") and so on for multiple months/years etc...
I'm unsure how to approach this since the day and time portions are not all the same length.
Any thoughts?
Thanks!
I have some excel data with a text field that I'm trying to convert to a sortable date:
The field contains (ex. "4DEC13, 9:19" "18NOV13, 9:07" 15NOV13, 11:50") and so on for multiple months/years etc...
I'm unsure how to approach this since the day and time portions are not all the same length.
Any thoughts?
Thanks!