再试试:- Sub 取值()
- Dim arr, i&, j&, k$, arb, arc, l&, m&, n&, ard(1 To 10000, 1 To 2), are, V&, P&
- arr = Sheet1.Range("A1").CurrentRegion
- For i = 1 To UBound(arr, 2)
- For j = 1 To UBound(arr)
- k = k & arr(j, i)
- Next j
- Next i
- arb = (Len(k) - Len(Replace(k, "201S", ""))) / 4
- arc = Split(k, "201S")
- l = IIf(UBound(arc) > arb, arb, UBound(arc))
- For m = 0 To l
- n = n + 1
- ard(n, 1) = Right(arc(m), 2)
- Next m
- are = Split(Replace(k, "201S", "201S々"), "201S")
- For V = 0 To UBound(are)
- If InStr(are(V), "々") Then
- P = P + 1
- ard(P, 2) = Mid(are(V), 2, 3)
- End If
- Next V
- With Sheets("提取")
- .Range("B5:B10000").ClearContents
- .Range("B5").Resize(n) = Application.Index(ard, 0, 1)
- .Range("f5").Resize(n) = Application.Index(ard, 0, 2)
- End With
- End Sub
复制代码 |