|
billyzhang0609 发表于 2015-11-3 15:05
又遇到问题,就是当不含有关键字“次”的单元格在里面的时候,会有一个数字抠出来,好像都是“9”
其实 ... - Sub tt()
- arr = Range("f1:f" & [f65536].End(3).Row)
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 2 To UBound(arr)
- If InStr(arr(i, 1), "次") = 0 Then '不含“次”
- brr(i, 1) = 0
- Else '含次
- x = Split(arr(i, 1), "次")(0)
- If Len(x) Then
- For j = 1 To Len(x)
- If IsNumeric(Mid(x, j, 1)) Then Exit For
- Next
- If j <= Len(x) Then brr(i, 1) = Val(Mid(x, j)) Else brr(i, 1) = 0
- End If
- End If
- Next
- [a1].Resize(UBound(arr)) = brr
- End Sub
复制代码 |
|