Oct 15 2019 03:26 AM
Hi,
I have below date format which is copy/pasted from another source and I cannot seem to be able to figure out how to convert it to a date format in Excel...
1:50 PM - Wednesday, November 13
I've tried various text to column options, but I just can't get there.
What I would love it to be converted to is:
dd/mmm/yyyy hh:mm
Oct 15 2019 03:52 AM
SolutionOct 15 2019 04:06 AM
@Wyn Hopkinsthank you so much - that works so well!!
Oct 15 2019 03:52 AM
Solution