chensir 发表于 2013-12-6 17:22
多谢,函数我可以解决,需要用VBA - Sub test()
- Dim i, j, a, arr, arr1
- Sheet1.Activate
- arr = Range("B2:B" & [B65536].End(3).Row)
- ReDim arr1(1 To UBound(arr, 1), 1 To 1)
- For i = 1 To UBound(arr)
- For j = 1 To Len(arr(i, 1))
- a = Mid(arr(i, 1), j, 1)
- If InStr(arr(i, 1), "(") = False Then
- If a Like "[A-Z]" Then
- arr1(i, 1) = arr1(i, 1) & a
- End If
- Else
- arr1(i, 1) = Mid(arr(i, 1), InStr(arr(i, 1), "(") + 1, _
- InStr(arr(i, 1), ")") - InStr(arr(i, 1), "(") - 1)
- End If
- Next j
- Next i
- [A2].Resize(UBound(arr1, 1), 1) = arr1
- End Sub
复制代码 |