If yu have a set of mixed numbers and letters and want only the nine-most
numbers, then:

=RIGHT(returnnumerals(A2),9)

where the UDF is:

Public Function ReturnNumerals(rng As Range) As String
Dim sStr As String, i As Long, sStr1 As String
Dim sChar As String
 sStr = rng.Value
 For i = 1 To Len(sStr)
   sChar = Mid(sStr, i, 1)
   If sChar Like "[0-9]" Then
     sStr1 = sStr1 & sChar
   End If
 Next
ReturnNumerals = sStr1
End Function