I have a large quantity of data that comes in the format shown in Column A. I'd like to separate that content in columns only containing the numbers. I've made a few attempts with mid, right, left, find, & text to column but no luck. I continue to come up just a bit short (still get dashes, catch a W or E, etc) due to the inconsistency in the way the data is entered. Can anyone tell me a formula to get the numbers isolated? Thanks for all your help!

Excel Help.JPG