With Range("A1:A" & Range("A6553").End(xlUp).Row)
.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar:="-", _
FieldInfo:=Array(Array(1, xlTextFormat), Array(2, xlTextFormat), Array(3, xlTextFormat))
.SpecialCells(xlCellTypeBlanks).EntireRow.Delete xlShiftUp
End With