Need to seperate
Okay I am doing something wrong here.
I have a little over 350 lines of information that look something like this:
001 - ROTOR WILL NOT TURN
I need to split the 001 from ROTOR WILL NOT TURN and get rid of the hyphen
altogther.
The problem is not all 001's are the same length, for instance, it could be
R05C22 TOTAL HUMAN-COMBUSTION.
So, I can't do a fixed width because it cuts out some of the data and the
other way seperates every hyphen.
I want it to look like this:
A B
1 001 ROTOR WILL NOT TURN
2 R05C22 TOTAL HUMAN-COMBUSTION
|