Hi Fred,

Thank you for your formula. I used it in my program.

Have a great week,
Ali

>>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",""),""))