High-light your data and pull-down:
Data Text to columns
use the space character as the separator. This will produce 4 columns.
Keep only the first
--
Gary''s Student - gsnu2007a


"newguy" wrote:

I have a worksheet I have imported from another source and the Date
column also has a time stamp with it which I don't want. I would like
to cycle through all the cells and seperate the date from the time
stamp and delete the time stamp.

Here is what I have:
13-Aug-2007 04:46:42 PM PDT

Here is what I want:
13-Aug-2007

Thanks