Text to columns limit output

I have a table 2 columns wide insert a column B and use text to columns to split column A into A and the new B but it keeps overwriting C with blanks.
start sample:

Level & Part Numbers	Description
5 NAS1130-3L20D	INSERT HCOIL 10/32 UNF .380L
5 NAS1130-3L20D	INSERT HCOIL 10/32 UNF .380L
5 NAS1130-3L20D	INSERT HCOIL 10/32 UNF .380L

Prepared to:

Level	Part Numbers	Description
5 NAS1130-3L20D		INSERT HCOIL 10/32 UNF .380L
5 NAS1130-3L20D		INSERT HCOIL 10/32 UNF .380L
5 NAS1130-3L20D		INSERT HCOIL 10/32 UNF .380L

Text to col desire

Level	Part Numbers	Description
5	NAS1130-3L20D	INSERT HCOIL 10/32 UNF .380L
5	NAS1130-3L20D	INSERT HCOIL 10/32 UNF .380L
5	NAS1130-3L20D	INSERT HCOIL 10/32 UNF .380L

Actual result:

Level	Part Numbers	Description
5	NAS1130-3L20D
5	NAS1130-3L20D
5	NAS1130-3L20D

Full code:

Please Login or Register  to view this content.

Area of concern:

Please Login or Register  to view this content.

Originally Posted by jindon

Data in col.A should have extra space at the end, so why not inserting 2 columns and delete one after the process...

Nope, didn't work, Same result... Also Col A is being trimmed so shouldn't have spaces at the end.

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks

Change this argument

FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 9), Array(4,9))