|
- Sub cc()
- arr = Split("," & [a1], ",")
- arr1 = Filter(arr, "女", True)
- r = UBound(arr1) + 1
- Dim arr3()
- ReDim arr3(1 To r, 1 To 2)
- For i = 1 To r
- arr3(i, 1) = i
- arr3(i, 2) = IIf(Len(arr1(i - 1)) = 4, Left(arr1(i - 1), 1), Left(arr1(i - 1), 2))
- Next i
- Range("d6:e17") = arr3
- End Sub
复制代码 |
|