How do I delete text ONLY from a Cell containing both numbers and letters?

[Jbouch]

I have a spreadsheet and it uses when the data imports it displays Ex- ".87 (ft)". having the text and parenthesis in the cell give me an error on the output of the program. There are thousands of these measurements, so I am looking for a quick way to accomplish this.

 

[rpaulson]

Find and Replace

 

[Jbouch]

Find and Replace

The Measurements vary so I would not be able to use that feature

Ex:

.773 (ft)
.594 (ft)
.387 (ft) ...

 

[rpaulson]

Find: " (ft)" without the quotes
replace with nothing.

this will remove the space and the (ft) and leave just the number