if the numeric portion is fixed length (always four characters), use the Left function e.g.

Left("1234-abc", 4)

yields "1234"

If the numeric portion is variable length, add a call to InStr:

=Left("1234-abc",InStr("1234-abc","-")-1)