- Sub Greenhand()
- Dim i&
- Dim arr
- Dim brr()
- arr = Range("g2", Cells(65536, "g").End(3))
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- If Left(arr(i, 1), 1) = "(" Then
- brr(i, 1) = Mid$(arr(i, 1), 2, InStr(arr(i, 1), "。") - 2)
- End If
- Next
- [f2].Resize(UBound(arr), 1) = brr
- End Sub
复制代码 |