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:
Area of concern:
Bookmarks