only extract numeric value from alpha numeric cell

For cells like 1.234 years you want to discard the last 6 characters, use:
=LEFT(A1,LEN(A1)-6)
For cells like 1.234years you want to discard the last 5 characters, use:
=LEFT(A1,LEN(A1)-5)
--
Gary's Student


"Fam via OfficeKB.com" wrote:

> 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
>

Thanks, it works great
Fam

Gary''s Student wrote:
>For cells like 1.234 years you want to discard the last 6 characters, use:
>=LEFT(A1,LEN(A1)-6)
>For cells like 1.234years you want to discard the last 5 characters, use:
>=LEFT(A1,LEN(A1)-5)
>> Good Morning ...
>> if I have a cell with alpha numeric value, is there any way to extract only
>[quoted text clipped - 13 lines]
>> Any help will be appreciated.
>> thx

--
Message posted via http://www.officekb.com