1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub Split_ColA()
Dim rg As Range, c1 As Range, c2 As Range
With ActiveSheet
Set c1 = .[A1]
Set c2 = .Cells(.Cells(Application.Rows.Count, 1).End(xlUp).Row, 1)
Set rg = .Range(c1, c2)
rg.TextToColumns _
Destination:=Range("B1"), _
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=True, _
Tab:=True, _
Semicolon:=False, _
Comma:=False, _
Space:=True, _
Other:=True, _
OtherChar:="/", _
FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)), _
TrailingMinusNumbers:=True
End With
End Sub |
Partager