>Hi Fred,
>
>I have another question again.
>
>Is it possible to caculate the value of the very right numbers of a character string with one function like?
>
>I mean like
>anmmjj123 which yield 123
>mmn23 which yield 23
>ooo89 which yield 89
>
>Thank you,
>Ali
If all the other characters are non-digits, you could do:
? VAL(CHRTRAN("test123",CHRTRAN("test123","1234567890",""),""))