Another way.

=--LEFT(F1,FIND(" ",F1))

HTH
Regards,
Howard

"Fam via OfficeKB.com" <u18245@uwe> wrote in message
news:5f5bbbab4e0ec@uwe...
> Good Morning ...
> if I have a cell with alpha numeric value, is there any way to extract
> only
> numeric value out of the cell?
> for example:
> 9 years
> 22 years
> 20.5 years
> 22.17years
> 22.17 years
> can it be just after some formula:
> 9
> 22
> 20.5
> 22.17
> 22.17
> Any help will be appreciated.
> thx
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200604/1