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:
View best response
This isn't very elegant but it seems to work
@Wyn Hopkinsthank you so much - that works so well!!