Hi, how do I break up a cell containing "12/31/2012 9:36:48 AM" into two cells : "12/31/2012" & "9:36:48 AM"? Any help is appreciated.