=LEFT(A1,FIND("-",A1)-1)

the above will return what's left of the first hyphen


=MID(A1,FIND("-",A1)+1,255)

will return what's to the right, if you have more than 255 character change
that accordingly

--


Regards,


Peo Sjoblom

"hshayhorn" wrote in message
...
I have cells that contain statements like ASL- Auto Selection Logic. I need
to take that cell and break it into two cells. One cell would be ASL and
hte
other would be Auto Selection Logic. There is no standard length of words
or
characters so I need to key off of the - in the line. Also, some of the
lines
have multiple - in them so I need to look for the first - from the left
and
go from there.

Can anyone help me?