I have a column with strings in this format
TIRES, RUBBER, SMOOTH, 18 X 5 X 12-1/8
TIRE DRIVE SMOOTH, 10-1/2 X 5 X 6-1/2 TIRE DRIVE SMOOTH, 10-1/2 X 5 X 6-1/2
SOLENOID, 24 VOLT, #841248 SOLENOID, 24 VOLT, #841248
I want to copy the non-duplicate part of each string to an adjacent column. For example:
Col B = SOLENOID, 24 VOLT, #841248
Then in adjacent columns, copy each numeric part.
Col C = 24
Col D = #841248
I have about 10,000 rows and am hoping there is a vba code that will help. Any suggestions?
TIRES, RUBBER, SMOOTH, 18 X 5 X 12-1/8
TIRE DRIVE SMOOTH, 10-1/2 X 5 X 6-1/2 TIRE DRIVE SMOOTH, 10-1/2 X 5 X 6-1/2
SOLENOID, 24 VOLT, #841248 SOLENOID, 24 VOLT, #841248
I want to copy the non-duplicate part of each string to an adjacent column. For example:
Col B = SOLENOID, 24 VOLT, #841248
Then in adjacent columns, copy each numeric part.
Col C = 24
Col D = #841248
I have about 10,000 rows and am hoping there is a vba code that will help. Any suggestions?