Opps: change last formula to
=TRIM(SUBSTITUTE(MID(A2,FIND(" ",A2),LEN(A2)),"- ",""))
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"LiveUser" wrote in message
...
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