SOLVED

Help with converting a date

Copper Contributor

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

 

 

3 Replies
best response confirmed by LocalG925 (Copper Contributor)
Solution

Hi @LocalG925 

 

This isn't very elegant but it seems to work

 

image.png

 

 

@Wyn Hopkinsthank you so much - that works so well!!

You're welcome
1 best response

Accepted Solutions
best response confirmed by LocalG925 (Copper Contributor)
Solution

Hi @LocalG925 

 

This isn't very elegant but it seems to work

 

image.png

 

 

View solution in original post