RE: pulling certain data out of a cell

From: "Jason Morin" <jasonjmorin@xxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 13 May 2005 07:34:00 -0700

Try:

=SUBSTITUTE(RIGHT(A1,LEN(A1)-12),"lyrs","")*1

Assuming the format is always:

lyyyy-mm-ddl"age"lyrs

HTH
Jason
Atlanta, GA

"D richardson" wrote:

>
> I have a cell that contains l1931-06-05l73lyrs
> I want to be able to pull off just the 73, is this possible
.

Follow-Ups:
- RE: pulling certain data out of a cell
  - From: D richardson

References:
- pulling certain data out of a cell
  - From: D richardson

Prev by Date: RE: how do i find data in multiple sheets in excel
Next by Date: RE: pulling certain data out of a cell
Previous by thread: Re: pulling certain data out of a cell
Next by thread: RE: pulling certain data out of a cell
Index(es):
- Date
- Thread