Sub a() Columns("A:A").TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _ :="©¦", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 2), Array(5, _ 1), Array(6, 1), Array(7, 1), Array(8, 1)), TrailingMinusNumbers:=True Dim i As Long For i = [a65536].End(xlUp).Row To 1 Step -1 If Cells(i, 1) Like "*©¤*" Then Rows(i & ":" & i).Delete End If Next End Sub 给个代码测试一下。 |