Make sure you include the "S"

Edit|replace
what: years <--- changed
with: (leave blank)
replace all

Dave Peterson wrote:

If your data always ends with "years" or " years", you could just select that
column, then

Edit|replace
what: year
with: (leave blank)
replace all

"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

--

Dave Peterson

--

Dave Peterson