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