Find All Characters After Last letter in String

[Tellm]

I have a string which contains both alpha numeric/characters and I need to extract all of the characters after the last letter. As an example I have:
ASDFG 123 4 SDFGH 6.0
SDFFGH 2562 SDFGGHJH aDFGGH 6.0 - 6.1

All I want is the 6.0 and 6.0 - 6.1

Is there anyway I can extract this information?

Thanks

[NBVC]

Try, assuming strings start in A1:

=TRIM(SUBSTITUTE(A1,LEFT(A1,(MIN(FIND(0,SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("97:122"))),0)&0)-3))),""))

copied down

[Tellm]

NBVC - many thanks for responding. My detail starts in cell reference H2 which I have changed in the formula however, the I am getting an error which is something to do with the "97:122" part of the formula. I am using I am using a 2003 version. Regards

[NBVC]

Actually, I am not sure it's the perfect formula... if it works for you great... you can actually just change to this:

=TRIM(SUBSTITUTE(H2,LEFT(H2,(MIN(FIND(0,SUBSTITUTE(UPPER(H2),"z",0)&0)-3))),""))

it works for the samples you gave.

[icestationzbra]

i found this CSE formula to be a little more robust:

Please Login or Register  to view this content.