I have a report with date and time column. The data looks like this:
11/6/2008 2:18:00 PM

I need to pull the date into one cell and the time into another. How can I
do this when the date and time will vary in the number of characters? i.e
=left(a1,9) will miss part of the date if were another character long, like
11/16/2006.

Thanks