atulrajratna
New Member
I have a long list of a text containing "mmm dd yyyy hh:mm:ss".
e.g.
May 21st 2013 21:42:04
Mar 22nd 2013 21:38:18
Dec 23rd 2013 21:37:15
Oct 1st 2013 21:35:48
Jan 1st 2013 21:32:37
Mar 3rd 2013 21:32:02
Apr 2nd 2013 21:29:51
Jun 20th 2013 21:28:19
Feb 21st 2013 21:25:30
I want to change it in dd-mmm-yyyy format. (time not required)
I trued it using left-find & mid formula but could not get proper date.
Please help me.
Thank you!
-Atul
e.g.
May 21st 2013 21:42:04
Mar 22nd 2013 21:38:18
Dec 23rd 2013 21:37:15
Oct 1st 2013 21:35:48
Jan 1st 2013 21:32:37
Mar 3rd 2013 21:32:02
Apr 2nd 2013 21:29:51
Jun 20th 2013 21:28:19
Feb 21st 2013 21:25:30
I want to change it in dd-mmm-yyyy format. (time not required)
I trued it using left-find & mid formula but could not get proper date.
Please help me.
Thank you!
-Atul