One way...

A1 = [10/24/10 11:45PM]

=--REPLACE(LEFT(A1,FIND(" ",A1)),1,1,"")

Format as Date

--
Biff
Microsoft Excel MVP


"Sara" wrote in message
...
The data that I have looks like this:
[10/24/10 11:45PM]

And I would like to just get the date like this:

10/24/10

Is there any way to do this in Excel with a formula?

Thanks!!

Sara