How to remove text and save numbers

Hello everyone,
I have attached an example of my document, which I have to edit. My task is to get rid of text in the cells and leave only numbers. What formula should I enter into the cells in column B to solve it?View attachment Book1.xlsx

Try this:

=IFNA(-LOOKUP(1,-LEFT(A1,ROW(A$1:A$15))),-LOOKUP(1,-RIGHT(A1,ROW(A$1:A$15))))