You might have to play about with Data | Text-to-Columns a few times.
Highlight column A then Data | T-t-C and specify <space as delimeter.
If you are not interested in any of the other data, then you could
delete columns B to F. Then repeat, but specify semi-colon as
delimiter. Repeat again with <oblique as delimiter, and continue until
you have exhausted all combinations.

You could then do Find & Replace (CTRL-H) to do some further clean-ups,
eg:

Find What ?
Replace with NA

Find What 1-123
Replace with 123

I'm not sure if you can replace the error message with NA using Find
and Replace - if you have many of these you could apply a filter and
select #NA then overtype NA in the top-most visible cell and copy this
down the visible cells. You could also do this for the 0 entry.

Bit tedious, but I hope this helps.

Pete