excel怎么取单元格中的数字数值

Function GetNumber(IsStr As String) As String
  Dim I As Integer
  Dim Char As String
  For I = 1 To Len(IsStr)
    Char = Mid(IsStr, I, 1)
    If Char Like "[0-9]" Then GetNumber = GetNumber & Char
  Next
End Function

=LOOKUP(9^9,--LEFT(C6,ROW(1:9)))

=MID(C5,MIN(FIND(ROW(1:10)-1,C5&"0123456789")),9)

=LOOKUP(9^9,--LEFT(MID(C7,MIN(FIND(ROW(1:10)-1,C7&"0123456789")),10),ROW(1:9)))