Parse After Each Dash

I work in the Oil and Gas industry and deal with large data tables that have "Location Codes" for lack of a better term.

The problem is that not all Databases use exactly the same format of code, they will however always have the following:

xx-xx-xx-xx ---> ie. a string of four numbers each seperated by a Dash.

This string sometimes will appear after a text name of varying length. With this in mind I would like to parse the four numbers into four different columns.

Things I've tried with some success:

Using the "Right" function to break off the location code off the end of the entire name, and then using the ".parse" command in VB to seperate the numbers at given intervals.

This is great for certain purposes however because the four numbers are not always 2 digits, and the ".parse" command cuts at given intervals it is hard to accurately parse an entire set of data.

Some examples of location Codes are given below:

9-23-78-11
WEST DOE 11-16-81-15
KNOPCIK 3-9-73-9