I have data in the form of dates and times that need to be sorted. I want to convert the data to general format. My problem is that I have PST (Pacific Standard Time) and PDT (Pacific Daylight Time) included in the cells. How can I get Excel to ignore the PST and PDT abbreviations in each cell and convert my data to the general format?