Your table is in bad shape.
Mixing numbers with strings and symbols in a single cell. It is "pain in the ass" to try to split them given the free form of values.
It is the result of a combination of mistakes - wrong field type, poor normalization, and without proper input validations.
IMHO, as it is now , it is not feasible to solve it at the SQL level as SQL is NOT meant for such things. You may want to do it at code behind but again it is 'pain in the ass'. The least option is to redesign this table. Ultimately, I would recommend revamping the whole database as I suspect the other tables are in bad shapes either.
Learn more about:
Introduction to database design[
^]
If you cannot do it, you should get an expert to do it for you. The database is the root of an application, if it is not designed correctly, the whole application will be a flop.