Hello,

I have a date/time stamp stored as text in A1 "Tuesday, September 19, 2017 10:00 PM (IMP)"
i want to separate it in four columns >> Tue, 19-Sep-2017, 10:00 PM, IMP

I used datedif but its not working. please help me convert this.

Thanks