My raw data contains dates in this format:
05/27/2011 12:52:46PM
(That's all in one cell.)
I need to sort this data chronologically from oldest to most recent. The sorting must work across years, so that, for example, December 2010 appears before January 2011.
Excel does recognize this...