Thanks...Your right that worked assuming the length is always the same in
some instances the lyyyy-mm-ddl is missing and you are left with ll45lyrsl,
the lyrsl is a constant... is there a way to pull off from the right after
the 5 characters lyrsl.

"Jason Morin" wrote:

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