formula help

[ganeshpoojary05]

hi all,

i have a data which contains alphanumeric characters, i need a formula to remove the alphabetic characters.

for example:
msrtsc156458955594
gfdgfh156686489256
dfuyj1565489545
wdssd4256356

I want my output as:
156458955594
156686489256
1565489545
4256356

Thanks in advance...

 

[GlennUK]

Are the alphabetic characters always at the front of the strings?

 

[anglais428]

if data in column A starting at A1:

=RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1)