2,464
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Sub test()
Dim i As Integer, j As Integer, w1 As String, w2 As String
Dim bStr As String, s As Integer
bStr = Sheet1.Range("a1").Value
s = 1 '''米 公里
Do
i = InStr(s, bStr, "步行约", vbTextCompare)
If i > 0 Then
w2 = ""
For j = i + 2 To Len(bStr)
w1 = Mid$(bStr, j, 1)
Select Case Asc(w1)
Case 46, 48 To 57
w2 = w2 & w1
Case Asc("米")
Debug.Print w2
s = j
Exit For
Case Asc("公")
Debug.Print CStr(Val(w2) * 1000) ''
s = j
Exit For
End Select
Next
Else
Exit Do
End If
Loop
End Sub
'
.至于距离种类,自己判断