only extract numeric value from alpha numeric cell

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

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