How to extract numerical characters?

[EduPAz]

Hi,

Can someone please help me with this doubt?

I have the fallowing data and I would like to extract only the numerical characters:


R111----> 111
AX12---->12
ADF1234--->1234
WRT999--->999


Thanks!

Edu

 

[Joe4]

See the formula at the top of this link here: https://www.extendoffice.com/documents/excel/1622-excel-extract-number-from-string.html

 

[István Hirsch]

If the numbers are always at the end of the string:

=MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),50)+0