|
- Sub aa()
- Dim i%
- For i = 1 To Len([B2])
- If Mid([B2], i, 1) = "(" Then
- i = i + 1
- Do While Mid([B2], i, 1) = " "
- i = i + 1
- Loop
- If [B2].Characters(i, 1).Font.ColorIndex = 3 Then
- [C5] = Mid([B2], 1, i - 1)
- Do While Mid([B2], i, 1) <> " " And Mid([B2], i, 1) <> ")"
- [C2] = [C2] & Mid([B2], i, 1)
- [C5] = [C5] & " "
- i = i + 1
- Loop
- End If
- End If
- If [C2] <> "" Then [C5] = [C5] & Mid([B2], i, 1)
- Next
- If [C2] = "" Then [C5] = [B2]
- End Sub
复制代码 |
|