One way:

=INT(A1)

format as a date if necessary.

In article ,
"JT" wrote:

I need to be able to separate the Date and Time from thousands of entries
that are list as follows:

2/6/2005 2:36:45 PM

If the above is in the same cell, how can I get 2/6/2005 separated out into
its own cell?