Hi Greg,

Try this one where A1 is the reference to your cell with RR1 or
something.

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&{0,1,2 ,3,4,5,6,7,8,9})),1024)

It will extract the numeric values.

I'm sure i saw a more elegant version of it in this group a couple of
days ago but i think this will work aswell..