Extract all text to the left of a hyphen ???

Use this:

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

To get the other part:

=RIGHT(A1,LEN(A1)-FIND("-",A1))

You might like to wrap TRIM( ... ) around those to remove any extra spaces that you don't need.

Hope this helps.

Pete