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