hshayhorn wrote:
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?



=TRIM(LEFT(A1,FIND("-",A1)-1))
=TRIM(MID(A1,FIND("-",A1)+1,9999))