Hi all,
I've been trying to get a string in the format of 31st Aug 17 4:12pm AEST into a usable date format.
Things I've tried so far include but are not limited to the DATEVALUE function, =LEFT(O2,2) function, however not sure how to make sure when numbers go from single to double digit it pulls across.
Any help would be greatly appreciated.
<colgroup><col width="64"></colgroup><tbody>
</tbody>
I've been trying to get a string in the format of 31st Aug 17 4:12pm AEST into a usable date format.
Things I've tried so far include but are not limited to the DATEVALUE function, =LEFT(O2,2) function, however not sure how to make sure when numbers go from single to double digit it pulls across.
Any help would be greatly appreciated.
<colgroup><col width="64"></colgroup><tbody>
</tbody>