Retain date and remove text from cell

Hello,

 Is there any formula, to delete text and retain only dates.

 Let me explain more detail.

 I have a excel file with more than 1500 entries.

One of the column has date and text separated with space, but now my boss told me to remove the text and retain only date.

 Date format is MM/DD/YYYY.

 Eg. 6/10/2009
(see Signature Block, Optical Transport Service/Longhaul Service Order Form)

 i want to retain 6/10/2009 and want to delete the all other text.

 It would be easy if there is any formula to do it.

If you can count on a space character after the date, you can use this:

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

The FIND function is critical because you likely won't have exactly the same number of digits in the date through the year.