Use the text to column function

Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"),
DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 2), Array(3, 9), Array(6, 2), Array(31, 9), _
Array(32, 2), Array(43, 9), Array(46, 2), Array(63, 9)), _
TrailingMinusNumbers:=True


"JN" wrote:

Hi,

I have a few thousand rows that are paired like the following:

1ab ][ 128103406101993004040000
10.90.134.2 | 00:0E:5C:E6:CA:AA

What i would like is to have just one row in the following format:

A1 B1 C1
D1
1ab 10.90.134.2 00:0E:5C:E6:CA:AA 128134...

Thanks for your help.
JN