extracting numbers from a cell with letters and numbers

Hello-

Excel 2007

I have a large column of data (150+ rows). In each cell there is a number with an "hrs" label attached. example: "1,000 hrs" or "8,500 hrs".

Can anyone tell me if there is a way to extract only the hours (or delete the "hrs" text from each cell) so that I can use the numerical values in other formulas?

Thanks in advance.

Try this

=--SUBSTITUTE(A1," hrs","")

That worked great. Thank you very much.