delete text but not numbers

[smokenack]

I have cells that contain values such as MR28, E14, 56 etc.

I want to get rid of the text to leave 28, 14, 56 etc.

A formula solution is prefered please

thanks for looking

Nick

 

[Andrew Poulsom]

Try:

=LOOKUP(9.99999999999999E+307,--RIGHT(A1,ROW(INDIRECT("1:15"))))

 

[smokenack]

thanks Andrew absolutely what I needed. I'll now spend the rest of the evening trying to understand how on earth it works!

thanks again

Nick