- Sub test()
- Dim ar
- Dim i As Long
- ar = Range("a2:a" & [a1048576].End(xlUp).Row)
- For i = 1 To UBound(ar)
- If InStr(ar(i, 1), "SUB") Then
- ar(i, 1) = Left(ar(i, 1), Len(ar(i, 1)) - 7)
- ElseIf InStr(ar(i, 1), "TA") Then
- ar(i, 1) = Left(ar(i, 1), Len(ar(i, 1)) - 6)
- Else
- ar(i, 1) = Left(ar(i, 1), Len(ar(i, 1)) - 2)
- End If
- Next
- Range("b2:b1048576").ClearContents
- Range("b2").Resize(UBound(ar)) = ar
- End Sub
复制代码 试试这个 |