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

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
>

Using Data > Text to columns will work if the data is still in text format.
However, if Excel converted the date and time stamps to dateserial values
(numbers), then you may have to insert a new column to the right of the
Date/Time, and use a formula:

B1: =Int(A1)

Copy and PasteSpecial the values back into the column, then delete the
original column of Date/Time.

--
Regards,
Bill Renaud