|
楼主 |
发表于 2016-9-20 21:12
|
显示全部楼层
Sub 提取()
Dim i%, k%, arr, brr
arr = Split(Range("A1").Value, ",")
ReDim brr(1 To UBound(arr), 1 To 2)
For i = 0 To UBound(arr)
If InStr(arr(i), "女") Then
k = k + 1
brr(k, 1) = k
brr(k, 2) = Replace(arr(i), "(女)", "")
End If
Next
Range("B6").Resize(k, 2) = brr
End Sub |
|