I have an excel spread sheet that has rows with everything in the same column like this.
I need to write a script that will split it out...
The 1st and 2nd characters need to be deleted.. then the first seven are the part number and the remaing characters are the serial number
So the first line should be 2373-JTU 990L8MA
the second line should be 2373-PU7 99WYGCW
the third line should be 2373-1WU 99AH1F0
Can anyone help me write a script or macro that would split this column out for me?